Alteryx Designer Discussions

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

Transpose tool

nlevinson
5 - Atom

Hi, I am having a hard time cleaning my data. I have data where there is one row that is "name" the next row is actual employee names, Then the next row is city then the next row is actual cities they live in, I need help on how to make "name "the column name and "suzzy" the actual content of the columns. 

1 REPLY 1
Luke_C
14 - Magnetar

Hi @nlevinson, can you provide an example dataset? It sounds like your data is already transposed so you would want to check out the crosstab tool to get the data into separate columns 

Labels