Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
6 years ago

Sub-Headers in Excel File Data Source

I have an excel data source that has a header and then a sub-header and unsure how to handle it without maybe removing the month header and just sticking with the CW (Calendar Week) Header, although ...
Need Help
Tips and Tricks
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi StuartSmith 

 

You can do some Power Query Transformation and keep both if that's what you after?

If you need some help, please provide the data sample is useable format ( something that can be imported or pasted ) into the Power Query Editor

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • StuartSmith's avatar
    StuartSmith
    Power Participant
    6 years ago

    Thanks,  I have hoping to attach the file, but no option for that. I have tried posting the table from Excel, but it keeps on failing.  Sorry to be a pain, whats the best we to get you the table example.