VBA Code to transpose data from Sheet 1 to Sheet 2 in a specific order

[zicitron]

Hi all,

I'm using Excel 2013 and I need help for a VBA code that will help me transpose data from Sheet 1 of my workbook to its Sheet 2. However, the "transpose" needs to be in a specific order.

Please have a look at the attached file. My original data is in Sheet 1 and I need it to transpose into the data shown in Sheet 2.

transpose example.xlsx

Thanks for your help.

-Ali

[MickG]

Try this:-
Results sheet2.

Please Login or Register  to view this content.

Regards Mick

[kalak]

Please Login or Register  to view this content.

[zicitron]

Thank you MickG! Works beautifully! Just what I was looking for!

[zicitron]

Kalak, I will have a look at your solution too and report back. Thanks.

[MickG]

You're welcome
NB:- "Kalak's" code is a much better effort !!!!!

[kalak]

Thanks Mick.

I tried them both and both seem fine to me.

Only if there's a large dataset ...