Forum Discussion
Transform duplicate rows into columns ordered by categories
Hi all, I got to transform duplciated category rows into columns using: = Table.Group(Source, {"ID", "ORDER"}, {{"CATEGORY", each Text.Combine([CATEGORY], ","), type nullable text}}) then split th...
Hi ronrsnfld,
Fair enough but I didn't realize the "dummy data" would be a big deal, maybe I need reformulate the question:
How do I order the data get the same sequence before transforming it?
Cheers,
One way would be by using the Table.Group function.