Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

HOW TO TRANSFORM columns into row using power query ?

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

 

 

 

Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago
    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

     

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    4 years ago
    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