Transpose columns to rows in Excel

EnriqueLDE — Tue, 23 Mar 2021 14:44:03 GMT

Hi all,

I have this input:

And I need this output:

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

topic Transpose columns to rows in Excel in Talend Studio

Transpose columns to rows in Excel