Forum Discussion

udian's avatar
udian
Helper III
8 years ago
Solved

Pivot Excel Data

Hi,

 

i wish to pivot my excel data so that it will look like the bottom one.

How can i achive this?

 

Thanks!

Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    udian

     

    Hi, 

     

    In Query Editor.

     

    1. Select the column with the Budget / Actual

     Transform - Unpivot Other Columns

    2.  Select the column with Budget / Actual

      Pivot  Column:  Value 

     

    Regards

     

    Victor

     

     

     

     

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    8 years ago

    udian

     

    Hi, 

     

    In Query Editor.

     

    1. Select the column with the Budget / Actual

     Transform - Unpivot Other Columns

    2.  Select the column with Budget / Actual

      Pivot  Column:  Value 

     

    Regards

     

    Victor