Transpose Data Using Macro

Hi,


I am at a loss for how to do this. I attached a example of the data I'm trying to transpose. I have the current data on the left and pasted the result I'm going for on the right.

Thanks,

Jim

Try the attached

Please Login or Register  to view this content.

Thanks Jindon,

Quick question...my orginal sheet is much longer. What do I edit to extend the Macro further down the sheet?

Just try the code with your original data and see what happens.

nevermind...I had a open cell in column A and it stopped. Works perfect!

Thanks!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Jindon,

I have one more question. Can there be something added to the script to skip over blank rows? The script stops when it hit a black row.

Thanks again,

Jim

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

If it doesn't work, I need to see your workbook again...

good to go!

Happy Holidays!