Hello Designers, I have the following table: LocationParameter 1Parameter 2DifferenceDifference %A108225B2014642.85C30201050 How do I convert into simple transpose like this: LocationABCParameter 1102030Parameter 281420Difference2610Difference %2542.8550 Thanks in advance. Kalindi

Rows to column simple transpose

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

Transformation

Accepted answers

lmorrell

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!

Rows to column simple transpose.yxmd

All comments

lmorrell

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!

Rows to column simple transpose.yxmd

kalindideshmukh

@Imorrell, Thanks a lot!

allanxu23

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

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157