How to transpose columns to rows dynamically

Question

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.

Name123…...NP1    P2    P3    ….P35         And I would like to transpose the data into :      Name P1P2P3…P351    2    3    ….N

griffinwelsh · Accepted Answer

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