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
Solved! Go to 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
Awesome, that did the trick!
What happens if you have a bigger matrix to transpose? Say something like 4 * 100