Forum Discussion
Merged Cells in Source
Try following the article in link. It addresses your issue using PowerQuery/PowerBI using M query expression language.
https://wessexbi.wordpress.com/2014/02/27/unpivot-nested-headings-with-power-query/
This is pretty typical operation needed to analyze free census data that's provided by governments. Which are often organized using multi level headers.
Awesome, I'll give it a read!
Thanks for the quick reply...
Try following the article in link. It addresses your issue using PowerQuery/PowerBI using M query expression language.
https://wessexbi.wordpress.com/2014/02/27/unpivot-nested-headings-with-power-query/
This is pretty typical operation needed to analyze free census data that's provided by governments. Which are often organized using multi level headers.
Awesome, I'll give it a read!
Thanks for the quick reply...