Forum Discussion
Anonymous
2 years agoNot applicable
Fill down and Transpose the multiple layered merged columns
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
Initial Source
Desired output via PBI Query editor
2 Replies
- PijushRoy
Community Champion
Hi Anonymous
Please share sample data in excel format
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- AnonymousNot applicable
Hi, I've updated sample excel link, thanks!