Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
EnriqueLDE
Contributor II
Contributor II

Transpose columns to rows in Excel

Hi all,

 

I have this input:

0695b00000DtK7TAAV.png 

And I need this output:

0695b00000DtK7EAAV.png 

 

Basically I have to do these steps:

- Group By "ID" (column 1) so there's only a row for each ID

- Grupe By and Transpose"Type" (column 2)

- Transpose "Stocks" (column 3) and join with "ID" and new "Type" row

 

I've been trying unsuccessfully some components like tPivotToColumnsDelimited, tUnpivotRow or tNormalize to transpose rows. Is it posible to achive that output? Thank you!

 

Regards,

Enrique

Labels (2)
0 Replies