Forum Discussion
jtc
7 years agoFrequent Visitor
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 na...
- 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!
Tahreem24
7 years agoSuper User
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!