- 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!