I have a table with the following structure, due to visualization and measuments I have to transform it in to this format:
I need your help please!
Go to Solution.
It’s my pleasure to answer for you.
According to your description,I think you can edit it in PQ.
If it doesn’t solve your problem, please feel free to ask me.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Hi @Anonymous ,
In Power Query, multi-select (hold down Ctrl wihle clicking) your [Period] and [Division] fields.
Go to the Transform tab on the ribbon, find the little dropdown button by 'Unpivot Columns' and select 'Unpivot Other Columns'.
Proud to be a Datanaut!
@Anonymous , Try unpivot
https://radacad.com/pivot-and-unpivot-with-power-biVideo : https://youtu.be/2HjkBtxSM0g
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!