Forum Discussion
Solved
Group rows in one column by another column.
Hi I want to convert this to two rows: So that it looks like this: I've tried the usual 'group by' and pivoting, but I've got stuck! I've also been experimenting with con...
Hi,
Use Table.Group with Text.Combine
= Table.Group(PrevStep, {"ID"}, {{"Values", each Text.Combine([Values],","), type text}})Stéphane
Many thanks Stéphane!
That is really much appreciated - that saved the day 😊
Hi,
Use Table.Group with Text.Combine
= Table.Group(PrevStep, {"ID"}, {{"Values", each Text.Combine([Values],","), type text}})Stéphane