power query - group/pivot

[ccsrtw]

I have a table with two columns:

ID                                        Product  

006F000000bqOUHIA2	Apple
006F000000bqosaIAAB	Banana
006F000000dqoLdIAI	Pear

There are dupes in the ID column. I want to essentially group the IDs and merge their products together so instead of each combination of ID and Product getting its own row, it would look more like (no more dupes in ID):

ID                                        Product  

006F000000bqOUHIA2	Apple; Banana
006F000000bqosaIAAB	Banana; Orange; Pear

Thanks!

[Vvelarde · Accepted solution]

@ccsrtw

Hi, A alternative in DAX:

Create a New Table(from Modeling) and use this:

Table =
SUMMARIZECOLUMNS (
    Table1[ID],
    "FruitList", CONCATENATEX ( Table1, Table1[Fruit], "," )
)

[ccsrtw]

That gets it done, thanks!