Transforming one large column into multiple distinct columns based on a third column

hi tking,

first group by rowNumber, make sure you change Operation to 'All rows'. You could also change the new column name to something more meaningfull than Count, e.g. newDisplayValue.

Then add a custom with this code: Table.Column([newDisplayValues],"displayValue")

Now you will see that the new column has an expand button in the title bar. Click on this and select Extract values, and separate the values with a delimter, e.g. ||. 

Next split the new column by the delimter you choose.

Finish off by removing the newDisplayValue column

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.