Fill down and Transpose the multiple layered merged columns

[jeongkim]

Hi,

I figure we can fill down and tranpose the row/columns for merged rows/columns to make multiple layered merged columns be structured(desired output) but it requires query adjustments when we add new columns such yellow below(and even do not know how many columns will be added)?

Sample Excel file

https://nokia-my.sharepoint.com/:x:/r/personal/marc_kim_nokia_com/_layouts/15/Doc.aspx?sourcedoc=%7B...

Initial Source

Desired output via PBI Query editor

[PijushRoy]

Hi @jeongkim 

Please share sample data in excel format
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[jeongkim]

Hi, I've updated sample excel link, thanks!