How to undo a crosstab later in the same workflow

[KanMag]

Hi, 

I used crosstab tool (which generated 5 new columns) to get one part of the results required for an analysis.

For the second part, in the same workflow, can I get my those same columns in the pre-crosstab format again? 

[KanMag]

Hi, 

I used crosstab tool (which generated 5 new columns) to get one part of the results required for an analysis.

For the second part, in the same workflow, can I get my those same columns in the pre-crosstab format again? 

[Emil_Kos]

Hi @KanMag,

This should help:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reverse-transpose/td-p/593912

[KanMag]

Hi @Emil_Kos

I did go through this one before posting this, & I don't think it would work for me.

Just to illustrate my situation, below is my pre-crosstab data

Mobile number	Event	Sum
XX	A	0
XY	B	0
YY	B	1
ZZ	C	1

Post crosstab:

Mobile number	A	B	C
XX	0	0	0
XY	0	0	0
YY	0	1	0
ZZ	0	0	1

Now I need to go back to the same format of data i.e. pre-crosstab. Would a transpose help?

[Emil_Kos · Accepted solution]

Hi @KanMag,

Please see the workflow attached:

The output: