Problem with Reshaping Excel data for Stata use.

Hello,

I always search in forums for my answer, but in this case I don't know how to search for it, so I might ask for something that is elaborately discussed. What I need is a VBA macro or something that can reshape my table.

If it works on this sheet, it will work on mine.

Your help is greatly appreciated as I really need this to fix my thesis (and deadline is running towards me!)

Thanks for the quick response!
When I run it, it keeps saying: object required.
I'm not exactly an excel expert so probably doing something wrong here. Would very much appreciate helping me out!