Forum Discussion
Solved
Agregate multiple names into one cell
Heelo dear community, I'm struggling to develop the code to obtain the 3 output below. My table contains 2 columns... Fruit and Name. It surely as to do with List but cannot make it work. Help wo...
You can add Custom Column:
For Customer with duplications, in the Custom Column dialog box:
Text.Combine( Table.SelectRows(#"Changed Type", (r)=>r[Fruit]=[Fruit])[Name], ", ")For Customer with no duplications:
Text.Combine(List.Distinct( Table.SelectRows(#"Changed Type", (r)=>r[Fruit]=[Fruit])[Name]), ", ")Thank you SundarRaj - its working 🙂
Hi DanFromMontreal , here's the solution to your query. I'll attach the output image and the snippet of the M code used below for reference. Thanks
Thank you SundarRaj - its working 🙂