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