Forum Discussion
Solved
Concatenate one column and group by multiple
Hey, I am trying to reduce the number of rows in my table, by concatenating distinct values in a particular column, but I want to leave all other columns the same. How would I go from this ...
try this:
Table.Group(Source, {"Item", "Client"}, {{"concat", each Text.Combine([Label], ", "), type text}})
Thank you this worked!