Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have data like below
I unpivoted 2 columns
But need to merge those 2 rows into 1 row
Like below
Please help
Thank you
Power Query can not create merge cell, but below code can give what you want almostly
NewStep=Table.UnipovtOtherColumns(PreviousStepName,{"ID"},"R/I -Severity","Values")