Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

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

How to Turn Rows in One Column Into Field Headers.

7 - Meteor

Hi everyone,


I'm trying to turn all my rows under F1 column into headers and having a hard time figuring out how to do so.


Original Data:


F1                             F2             F3               F4

Tax Owner               O1             O1              O2

Tax Code                 001            001             002

Entity Name             A                B                C


I want it to look like this:


Tax Owner              Tax Code             Entity Name

O1                           001                       A

O1                           001                       B

O2                           002                       C


I tried transposing and that doesn't seem to work. Any help would be greatly appreciated, thanks!

15 - Aurora
15 - Aurora

Hey @TwanD! The key here is to Transpose your data and then Cross Tab it. With your Transpose, you will want F1 to be your key field and the rest Data Fields. After that, in your Cross Tab tool, Group By the Name field and then set F1 as the new headers and the Value field as the values for new columns. You can then use a Select to rearrange and get rid of the Name field. Hope this helps!



7 - Meteor

Thank you so much, I had tried to crosstab after transposing as well but what I didn't do was checking the Name to be grouped for Value so then it wasn't crosstab correctly. Thanks again, greatly appreciate your help because it was driving me a bit nuts lol.

15 - Aurora
15 - Aurora

@TwanD No problem, glad to help! Things like this just come with experience. I remember the first time someone else showed me this trick to solve a similar problem I was having. 

5 - Atom

Thanks @Kenda  

5 - Atom

Thank you so much for this answer ,i was stuck with a similar issue for 2 hours 😞 and your answer helped. But i am still trying to understand the logic for how  cross tab and transpose work.

15 - Aurora
15 - Aurora
8 - Asteroid

After the result above result, seek advice on how to merge into single row as per attach.

7 - Meteor

I'm somewhat new to this forum, so I apologize if this should be a separate question versus being tagged to this current thread. I am trying to convert the following rows to columns, but can't quite figure it out with the Transpose & Cross Tab functions. Any help would be appreciated.




12 - Quasar



Hi, pls see the pic, you only need corss tab !