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!)