Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Sorry I can't explain this very well but I have the following table with a case_id and up to four values.
I want to merge all the "value" columns and create a new row for each so that the data is structured like this:
Any ideas? I was thinking this would be something I could do in M query but can't figure it out.
Solved! Go to Solution.
If you right click on the case_id header, you should see the option for 'unpivot other columns'.
Selecting this option should give you the structure you wanted.
there is an option unpivot column you just click unpivot other columns.
just an example
If you right click on the case_id header, you should see the option for 'unpivot other columns'.
Selecting this option should give you the structure you wanted.