Forum Discussion

jtc's avatar
jtc
Frequent Visitor
7 years ago
Solved

Rows to Columns

Hi,

 

I have a dataset as follows:

 

 

 

 

 

 

 

 

 

 

 

I wanted now to transpose the 2 values from the column type to two separate columns, meaning that I would have a column named DUR and another named POW with the corresponding value from the remaining columns.

 

Can anyone help?

 

Thanks

 

Need Help
  • Tahreem24's avatar
    Tahreem24
    7 years ago

    Hi jtc ,

     

    Basically you want to do the Pivot column. So go to Query Editor > Go to Transform Tab --> Select your Type Column --> click on Pivot Column Option in the Transform tab --> Then select on which column basis you want to pivot your data --> Then you'll get expected out like below screen shot.

     

    If I answered your question so please mark it as a solution! 

     

     

     

1 Reply

  • Tahreem24's avatar
    Tahreem24
    Super User
    7 years ago

    Hi jtc ,

     

    Basically you want to do the Pivot column. So go to Query Editor > Go to Transform Tab --> Select your Type Column --> click on Pivot Column Option in the Transform tab --> Then select on which column basis you want to pivot your data --> Then you'll get expected out like below screen shot.

     

    If I answered your question so please mark it as a solution!