Transpose Columns to Rows

Hello,

1) I changed my dataset in Excel from this:

2) to this(good result):

3)I tried the same thing in Alteryx but Transpose function gives the different result(all rows converted into two columns).

How I can get the same result as in the excel picture number(2).

Thanks for your help,
LuneLune

Datasets

Tips and Tricks

Best Practices

Accepted answers

FlorianC

Hi @LuneLune,

Please find attached the raw sample workflow.

Transpose Columns to Rows.yxmd

All comments

atcodedog05

Hi @LuneLune

You might have to use crosstab after this. Can you provide me the sample input as excel file i can help you out.

FlorianC

Hi @LuneLune,

After transposing your columns to rows using the transpose tool, you can use the cross-tab tool to pivot the toy names to columns as can be seen in the sample workflow attached.

Workflow

Transpose Columns to Rows.yxzp

atcodedog05

And Yup @FlorianC has the perfect solution workflow for it.

Hi @FlorianC

Just curious, is there is a specific reason why you have chosen to share a packaged workflow instead of normal workflow. Just curious 🙂

LuneLune

Thanks Florian,

Can you just share a normal workflow instead of the packaged one?

Here is my original file.

Toy Price.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703