Convert into a horizontal data table format

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

OUTPUT.xlsx

TEST INPUT.xlsx

Datasets

Reporting

Dynamic Processing

Preparation

Data Investigation

Accepted answers

JosephSerpis

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.

Screenshot 2024-10-01 161108.png

Crosstab_01102024.yxmd

All comments

JosephSerpis

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.

Screenshot 2024-10-01 161108.png

Crosstab_01102024.yxmd

alexnajm

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

Convert into a horizontal data table format.yxzp

OTrieger

@db89
Or you can use Make Columns

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703