I'm hoping someone will be kind enough to help me figure this out

I have an Excel file that was started years ago by someone else and although the data is in "groups". It is somewhat consistent and a clear pattern exists so I think it's possible to convert it to a flat file containing standard header columns and value rows. This would open the door to many possibilities with how the data could be used and/or published. I've searched high and low for a solution to this problem but haven't been successful yet.

Is there an easy way to accomplish this? In the illustrations below, there are 3 examples but my file has several thousand of these "groups" so doing this manually isn't an option. Any suggestions, guidance or instructions of how to fix would be greatly appreciated!


Current State Illustration
Excel_Screenshot_Before.jpg


Future State Illustration
Excel_Screenshot_After.png

Excel Example File
ConvertDataExample_041113.xlsx