Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a dataset that contains the below. I would like to create new rows for each record that are based on values in existing columns. Is this possible?
Example:
Before:
After:
Solved! Go to Solution.
That looks like : select userid column and 'Unpivot other columns' in Power Query
That looks like : select userid column and 'Unpivot other columns' in Power Query
That looks to have done it. I was trying to unpivot without remembering the dropdown to change the way it does it. Thanks!