Unpivot / Reverse Pivot data

[shivarajukuncham]

Friends i have a requirement to transpose few columns to rows from 50 columns and remaining columns should be in the same position.

please help me in this.

for your reference i am attaching the screenshots.

1. actual data

 

Required formatThanks,

Thanks,

Shivaraju

[danilang]

Hi Shivaraju

Any time you have complex data like yours, it always helps us if you can include sample data as opposed to a screen shot.  It just makes it much more likely that someone will help you if they don't have to spend 10 minutes recreating the input data.  It would also help to attach any workflow that you may have started on.

Thanks

Dan

[shivarajukuncham]

Hi Dan,

Thanks for your response, as you asked i am attaching sample data.

i am completely new to Alteryx i do not have any idea how to start.

Thanks,

Shivaraju

[BenMoss · Accepted solution]

Fun challenge.

Transpose is always the tool to use when pivoting your data, but your usecase requires some further prep.

Example attached.

Ben

[shivarajukuncham]

Hi Ben

thanks for your time and solution, this logic working as i expected but after transposing all my columns data arranging one below the other and when i get that into new column its writing in next row not in same row.

for your reference i am attaching a screenshot, issue highlighted in yellow color.

i tried multi row toll but not working, it will be a great help if any solution for this issue.

Thanks,

Shiva