Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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...
Proud to be a Super User! | |
Hi, I've updated sample excel link, thanks!