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 of the data:
ID Vendor
1 Alpha
2 Alpha
2 Beta
3 Alpha
3 Beta
3 Gamma
As an example, I want to condense that data down to the following format:
ID Vendor
1 Alpha
2 Alpha, Beta
3 Alpha, Beta, Gamma
Any suggestions would be greatly appreciated.
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
2 Replies
PhilCResolver I
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, 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}})