Forum Discussion
Solved
Merged Cells in Source
Hi Team, I have an issue where my source spreadsheet has merged cells in order to group different topics together. However when I add the data to PBI this is lost, which is understandable. (c...
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...
You can merge cells or rows or columns values easily using Dose for Excel Add-In:
https://www.zbrainsoft.com/excel-merge.html