How do I transpose data ?

[4a87b4a36dad41706305]

I m using a basic 30 x 30 matrix that requires for some statistical analysis to be transposed. It's extremely simple in Excel but I m not able to find anything similar to it.

I attached an example set that I would want to transpose, any idea or pointer would be highly appreciated

[Trifacta_Alumni · Accepted solution]

You could use the following wrangle script to transpose your data

unpivot col: first_name,last_name groupEvery: 1

pivot col: id group: key value: any(value) limit: 50

Just copy and paste each line when you click on adding a script

[4a87b4a36dad41706305]

Awesome, that did the trick!

[4d54873a545f04fb2ca3]

What happens if you have a bigger matrix to transpose? Say something like 4 * 100