Forum Discussion
StuartSmith
6 years agoPower Participant
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 ...
Mariusz
6 years agoCommunity Champion
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
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.