How to transpose columns to rows dynamically

[Varad_Paranjape]

I have variable number of columns in my output and a set number of rows (parameters). I would like to transpose the data dynamically within the Alteryx workflow. To explain this in detail, I have 35 rows and N columns and I would want the data to look like (N rows*35 Columns). How can I take a transpose of data when the number of columns are dynamic.

Name	1	2	3	…...N
P1
P2
P3
….P35
And I would like to transpose the data into :
Name	P1	P2	P3	…P35
1
2
3
….N

[griffinwelsh · Accepted solution]

See the attached sample. This will transpose data as requested and pick up new rows/columns as they are added.

[Varad_Paranjape]

Thanks a lot it worked, need to do a few modifications but the concept is quite clear now ! Thanks once again !