How to transpose table

[tl92]

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".

[tom_montpool · Accepted solution]

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.

[cbridges · Accepted solution]

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.

[cbridges]

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

[CDunhill]

There ought to be a rotate table tool