topic Re: Rows to column simple transpose in Alteryx Designer Desktop Discussions

Rows to column simple transpose

kalindideshmukh — Tue, 03 Sep 2019 23:52:04 GMT

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

Re: Rows to column simple transpose

lmorrell — Wed, 04 Sep 2019 00:27:02 GMT

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!

Re: Rows to column simple transpose

kalindideshmukh — Wed, 04 Sep 2019 00:29:17 GMT

@Imorrell, Thanks a lot!

Re: Rows to column simple transpose

allanxu23 — Wed, 08 Nov 2023 02:16:04 GMT

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