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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
This may not be possible, but I wanted to ask the experts here. I have a table that looks similar to this.
I need to transform this so that my column headers are [Month Name], [Brand], and [Sales]. The output would have 3 rows for each month and would look something like this:
I appreciate any help.
Solved! Go to Solution.
Hi @charbaugh
You can use Power Query Editor's Unpivot task
https://www.youtube.com/watch?v=-IMqkg35adA
Hi @charbaugh
You can use Power Query Editor's Unpivot task
https://www.youtube.com/watch?v=-IMqkg35adA
That was too easy. Thanks!