Forum Discussion
Multiple Header Column
Hi, I'm just using Power BI Desktop for the first time, I have a problem if in my excel file has multiple header like this: After I load into PowerQuery, it looks like this. ...
Anonymous,
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/Merged-Cells-in-Source/td-p/194473
Hi,
You may refer to my solution here - Rearrange a multi heading dataset into a single heading one which is Pivot ready. Please check both workbooks at that link.
Hope this helps.
Hi Ashish,
Thanks, so far it works for my dummy data! :)
Unfortunately I couldn't access due to permission issue on the second workbook.
Thanks
Hi,
You are welcome. I guess you mean that you cannot download the second workbook. Please try to download from your Home internet connection.