Transpose Tool with multiple rows

[Seemann]

Dear all,

I am fairly new to Alteryx and have problems with the Transpose Tool / Crosstab Tool.

I have a dataset with multiple lines and a single column that I need to be transposed. Coming from excel it is really easy to transpose data but in Alteryx I haven't figured out how to correctly use the tools to get what I need.

I have attached an excel file with a data input example and a tab for output, which represents what I want to achieve.

Thanks in advance!

[OllieClarke · Accepted solution]

Hi @Seemann 

The trick is to load the data with '1st row contains data' ticked

Then you can transpose and then cross-tab to get the structure you want


Hope that helps,

Ollie