community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

How to transpose table

Highlighted
Meteoroid

Hello everyone,

 

since I am a beginner, this is probably a very simple question - but searching for 'transpose table', 'rotate table', 'rows to columns' didn't yield any useful results for me.

 

So my question is: How can you rotate a table that the orientation is transposed?

E.g. if I have a table with 3 columns and many rows

 

A              |  1               | 9

B              |  2               | 8

C              |  3               | 7

D              |  4               | 6

E              |  5               | 5

F              |  6               | 4

...             |  ...               | ...

 

 

How can I turn it into:

 

A  |  B  |  C  |  D  |  E  |  F  |  ...

1  |  2  |  3  |  4  |  5  |  6  | ....

9  |  8  |  7  |  6  |  5  |  4  | ....

 

 

And vice versa?

 

I have tried to play around with crosstab and transpose - these didn't yield the desired results though.

For crosstab I wish there was the possibility to select multiple "Data fields".

 

ACE Emeritus
ACE Emeritus

Welcome to Alteryx!

 

Sometimes a single tool doesn't do what you want, in this case, a transpose and a crosstab will generate the results you want.

 

 

Bolide

See attached. In this case, you need to use a transpose tool AND a crosstab tool. Confusing, I know. I'm with you that multiple data fields in crosstab would be very helpful.

@thizviz
Bolide

LOL - great minds think alike, though in my case 4 minutes slower :-)

@thizviz
Labels