Forum Discussion
Noob needs help with shaping data
Hi all, Noob here! I need advice on how to shape the following excel data structure for Power BI to make sense of. Please help?
Hi,
I have solved a similar problem at this link - Rearrange a multi heading dataset into a single heading one which is Pivot ready.
Hope this helps.
Thim
Resolver V
Resolver VI would shape it like this, to put the catagories as par of the data.
I have colour coded, so it is easier to see where the original data would be put.
Hope this will help.
Hi Thim,
Thank you so much! I am very grateful!
I am thinking that I will need to use "Unpivot" columns. Am I on the right track?