power query - group/pivot

Question

I have a table with two columns:&nbsp;ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Product &nbsp;006F000000bqOUHIA2Apple006F000000bqosaIAABBanana006F000000dqoLdIAIPear&nbsp;&nbsp;&nbsp;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):&nbsp;ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Product &nbsp;006F000000bqOUHIA2Apple; Banana006F000000bqosaIAABBanana; Orange; Pear&nbsp;&nbsp;&nbsp;Thanks!

vvelarde · Accepted Answer

ccsrtw&nbsp;Hi, A alternative in DAX:&nbsp;Create a New Table(from Modeling) and use this:&nbsp;Table =
SUMMARIZECOLUMNS (
    Table1[ID],
    "FruitList", CONCATENATEX ( Table1, Table1[Fruit], "," )
)&nbsp;

Forum Discussion

power query - group/pivot

2 Replies

Related content

Power Query dates

Pivot or Group

Data transform using power query

ayuda en power query

Power BI downloaded PBIX does not contain Power Query queries

006F000000bqOUHIA2	Apple
006F000000bqosaIAAB	Banana
006F000000dqoLdIAI	Pear

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