How to Turn Rows in One Column Into Field Headers.

[TwanD]

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!

[TwanD]

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!

[Kenda · Accepted solution]

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!

[TwanD]

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.

[Kenda]

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

[Daniel_Aguirre]

Thanks @Kenda  ! This reply was simple and pretty straight forward and helped me to do exactly what I needed. 

Regards

[Adhiti]

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.

[Kenda]

@Adhiti 

Check out some of these helpful resources:

Cross tab Alteryx help page 

Cross tab tool mastery 

Transpose Alteryx help page 

Transpose tool mastery 

YouTube clip 

[sgwong]

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

[ljpanetta]

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.

[flying008]

@ljpanetta 

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