Transpose Output

Hi Everyone,

I have a generated file which is input file, want to transpose it in desired format (Output File). Find below sample data along with attachment.

Can anyone help ? Thanks in Advance !

AlteryxSampleData20_07.xlsx

Output

Accepted answers

binu_acs

@Inactive User One way of dong this

Transpose_20_07.yxmd

All comments

binu_acs

@Inactive User One way of dong this

Transpose_20_07.yxmd

unknown

Hi @binu_acs,

Thanks for your revert, but i have 50,000 input rows. What should i do in that case ?

binu_acs

@Inactive User how many columns are there ? Is the input file has the same format as you provided ? Would you able to provide sample input file with the actual column names with dummy data and expected output file ?

unknown

Hi @binu_acs,

Thanks for your revert, this solution helped me to understand how can i transpose data in my case.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703