Forum Discussion
Solved
Group and Concatenate
I'm a new user and struggling to find a way to do this through various ways of grouping and concatenating for my desired result (and AI has been no help!). I can usually work things out but getting d...
This can be done with Group By and customizing the aggregation that gets performed. Instead of returning all rows or for example a Min agg, we can use Text.Combine. Given the table you provided, the M in this step would give you your desired output
= Table.Group(Source, {"Manager name", "Manager email"}, {{"Direct Report", each Text.Combine( [Direct report], ", " ), type nullable text}})Output with test data:
This can be done with Group By and customizing the aggregation that gets performed. Instead of returning all rows or for example a Min agg, we can use Text.Combine. Given the table you provided, the M in this step would give you your desired output
= Table.Group(Source, {"Manager name", "Manager email"}, {{"Direct Report", each Text.Combine( [Direct report], ", " ), type nullable text}})
Output with test data:
Spectacular. That worked. Thanks a million!
