Excel 2007 : Transpose and offset

Hi,

I have spent days transposing information from multiple tabs into a single tab and a more user friendly format. Now, I am being asked to essentially re-do the entire exercise in order to transpose the data from 2 columns over... This would be extremely tedious, and I am wondering whether there is a way to program a macro for this or to use the offset functionality. Or anything else that would do the trick...

Example is attached.

Thanks for your help.