Excel Power Query Group by

Question

I have a table with two columns and some rows, and I want to create new columns for each individual row and different values.

I'm new to Power Query, but I already know the solution in VBA, so I need it there.

Answer 1

Try this

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"letters"}, {{"data", each Table.AddIndexColumn(_, "Index", 0, 1, Int64.Type), type table }}),
#"Expanded data" = Table.ExpandTableColumn(#"Grouped Rows", "data", {"group a", "Index"}, {"group a", "Index"}),
#"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Expanded data", {{"Index", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Expanded data", {{"Index", type text}}, "en-US")[Index]), "Index", "group a", List.Sum)
in  #"Pivoted Column"