Transpose tool

nlevinson

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. 

Luke_C

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