Forum Discussion
Solved
Convert three columns with repeating rows into a primary key, field columns, and associated rows?
Hi PowerBI folks, I'm at the last stretch of a fairly lengthy process where I ingested and parsed a series of XML files into constiuent tables. Each table contains a primary key (survey ID), a f...
Pivot the demographic column (demographic values in the Values section) and "Don't aggregate" under Advanced.
I think that's what your after.
Let me know.
NewStep= Table.Pivot(PreviousStepName,List.Distinct(PreviousStepName[Demographic]),"Demographic","Demographic Value",each _{0}?)