Forum Discussion
How can I consolidate duplicate rows into a single row with concatenated values?
I have a table I have grouped in Power Query that contains duplicate IDs. I want to concatenate the differences between the values so I can have one row per ID using Power Query. Here is an example o...
Try this:
#"Grouped Rows" = Table.Group(Source, {"ID"}, {{"Vendor", each Text.Combine([Vendor], ", "), type text}})Based on the solution from MarcelBeug in this post - https://community.powerbi.com/t5/Desktop/Combine-values-of-multiple-rows-in-one-row/td-p/308919
PhilC
Resolver I
Resolver ITry this:
#"Grouped Rows" = Table.Group(Source, {"ID"}, {{"Vendor", each Text.Combine([Vendor], ", "), type text}})Based on the solution from MarcelBeug in this post - https://community.powerbi.com/t5/Desktop/Combine-values-of-multiple-rows-in-one-row/td-p/308919
PhilC, thanks for the suggestion! That worked once I modified the code as follows:
#"Grouped Rows" = Table.Group({"ID"}, {{"Vendor", each Text.Combine([Vendor], ", "), type text}})