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 

 

Please see the attached file with the transformation applied, please follow the steps in Power Query Editor, 

Any questions please let me know.

 


Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn