Rows to column simple transpose

[kalindideshmukh]

Hello Designers,

I have the following table:

Location	Parameter 1	Parameter 2	Difference	Difference %
A	10	8	2	25
B	20	14	6	42.85
C	30	20	10	50

How do I convert into simple transpose like this:

Location	A	B	C
Parameter 1	10	20	30
Parameter 2	8	14	20
Difference	2	6	10
Difference %	25	42.85	50

Thanks in advance.

Kalindi

[lmorrell · Accepted solution]

Hi @kalindideshmukh 

Solution is attached.

The trick here is to push all your values into a single column by transposing your original table, and taking the results of that and crosstabbing it out. 

Additionally, to retain the order of the rows - I have created a sort column so that the outputs are visually identical. 

Hope this helps!

[kalindideshmukh]

@Imorrell, Thanks a lot!

[allanxu23]

You can just download the Transpose Excel Style Macro from Alteryx Community.