How to Transpose a Single Column to a Row

[djodts]

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.

[CharlieS]

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

[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 · Accepted solution]

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?

[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!