Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

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?

Ashish_Mathur
7 years ago
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.

Icon for Super User rank

Super User

7 years ago

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.

Anonymous
Not applicable
7 years ago
Awesome! Thank you so much!
- Ashish_Mathur
  Super User
  7 years ago
  You are welcome.
  - Anonymous
    Not applicable
    7 years ago
    Ashish_Mathur
    
    Hi Ashish! Sorry to trouble you.
    
    I am not clever enough to apply your example to my problem. There is an additional header row that I cannot figure out to transform. Can you take a look at the sample data file attached and provide a step by step? I will be most grateful!
    DumpFile_Extract.xlsx
    
    Note: Category 2 starts from column BN.
    
    Regards,
    Yee Pin

Related content