How to Transpose a Single Column to a Row

Hello,

Can someone advise how to transpose a single row? I'm looking to take my first column and transpose to a single row. The transpose and cross tab functions don't seem to do this simple task. I feel like this should be the default function but the cross-tab seems to want additional columns, but I only have this one. Thanks.

Tips and Tricks

Accepted answers

rafalolbert

Hi @djodts,

To get a perfect representation of your example, you can use Info tool to append column header with your values.

To transpose vertical view to horizontal, the correct tool to use is Cross Tab, but you require at least one more column (this is achieved with the use of Record ID).

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

workflow.yxmd

All comments

CharlieS

You could use a RecordID tool to easily add a second field to make this transformation possible.

20190805-CrossTab1.yxmd

djodts

Hi CharlieS

Thanks, but I am not sure I follow what to do after I add this column. The transpose tool seems (by the name at least) to be the one I should use, but the description of what it does is the opposite. The cross-tab seems by appearance to be what I need, but it seems to function much different than the transpose (I would assume it is just the opposite of transpose) but this tool wants to either split my data by a character or sum data. Neither of what I am trying to accomplish. Is there another tool that should be used? Thank you.

rafalolbert

Hi @djodts,

To get a perfect representation of your example, you can use Info tool to append column header with your values.

To transpose vertical view to horizontal, the correct tool to use is Cross Tab, but you require at least one more column (this is achieved with the use of Record ID).

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

workflow.yxmd

djodts

Thanks rafalolbert for your workflow. The concatenate worked great...just didn't seem intuitive to me so I didn't try it. I thought it was going to join both columns of data into one as a concatenate formula normally does. Thanks again.

jpscoralick

@CharlieS your workflow helped me a lot. Thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703