Convert into a horizontal data table format

[db89]

Hi All,

I have a table format as attached in the "Test Input" file which is column-wise. 

I want the output (as attached) using Alteryx. I have tried Transpose, but it seems to concatenate everything in one single row in case there are same "User Email" in the dataset.

Any help on this will be very appreciated. 

Thanks,

db89

[JosephSerpis · Accepted solution]

Hi @db89 you need a way to identify your data as rows one way is to use a muli-row tool. Then you can use a crosstab to pivot your data into a horizontal format.

[alexnajm]

This will be a combination of the Multi Row Formula tool to label rows, then a Crosstab to get it situated!

[OTrieger]

@db89 
Or you can use Make Columns