Forum Discussion
Solved
How to consolidate repeated records on a table
I have 2 tables, I would like to convert, left to right in this example. Only way I have done it is by using a lot of steps on Power Query which slows down my computer and often crashed (original fil...
The easiest way is with Power Query - query the source, group by ID using function as here for aggregation
let Source = Excel.CurrentWorkbook(){[Name="tblSource"]}[Content], #"Grouped Rows" = Table.Group(Source, {"ID"}, { {"Locations", each Text.Combine(_[Location]," + ")} } ) in #"Grouped Rows"Result is like
These are 2 tables, one is column A and B, the other is column D and E. I want to convert table 1 to table 2
The easiest way is with Power Query - query the source, group by ID using function as here for aggregation
let
Source = Excel.CurrentWorkbook(){[Name="tblSource"]}[Content],
#"Grouped Rows" = Table.Group(Source,
{"ID"},
{
{"Locations", each Text.Combine(_[Location]," + ")}
}
)
in
#"Grouped Rows"Result is like