Transpose columns to rows in Excel

[EnriqueLDE]

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