How can I consolidate duplicate rows into a single row with concatenated values?

[Anonymous]

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.

[PhilC · Accepted solution]

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

[Anonymous]

@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}})