HOW TO TRANSFORM columns into row using power query ?

[Anonymous]

Hi Team,

Can you please help me on power query to transformation?

Input

same input was loaded into the power bi file and link is attached in the below

Reference power bi File:  https://1drv.ms/u/s!Au-aOkl1BoHuhwcy-cGvuQhVMj6-?e=LSc2U2

Output

Please let me know if you need any more information

Thanks In advance

RGV

[wdx223_Daniel · Accepted solution]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Custom1 = Table.UnpivotOtherColumns(Table.Skip(Table.PromoteHeaders(Table.Skip(Table.Transpose(Table.CombineColumns(Table.Transpose(Source),{"Column2","Column3"},each if _{0}=null or _{0}="" then "Country" else Text.Combine(_,"-"),"n"))))),{"Country"},"Date","Actual")
in
    Custom1