In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transpose

Anthony_white
7 - Meteor

I'm ashamed to be asking this. How do you transpose vertical columns without concatenating the cells into a single cell? When using the transpose or cross tab tools I end up either losing cells or concatenating them. Below is similar to what I am trying to accomplish. 

 

Anthony_white_1-1665699494454.png

 

4 REPLIES 4
binuacs
21 - Polaris

@Anthony_white One way of doing this with the cross tab tool

 

binuacs_0-1665699743938.png

 

amjadmanasra
8 - Asteroid

Hello

another way to do this is by duplicating your value and using it in the crosstab 

amjadmanasra_0-1665700687247.png

 

 

 

Emmanuel_G
13 - Pulsar

@Anthony_white 

 

Another way of doing that just with formula tool in addition.

 

Emmanuel_G_0-1665700931859.png

 

Anthony_white
7 - Meteor

This worked perfectly! What I was having issues with was the headers because what I am actually transposing are directory paths, which make a mess as a header. 

Labels
Top Solution Authors