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.
9 Replies
I 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,
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.
You are welcome.
