Transpose data automatically based on the length of merged cells

I have a pdf file that I have converted into an excel file. I am trying to setup a file that would be a conversion tool for the same type of file to repeate this process on a regular basis. The excel file has merged cells in columns A and B. Column C contains a list of attributes related to the merged columns A and B. I’m looking for a solution through VBA or formulas that would be easy to repeate to convert the current format below into either the styles shown in Option 1 or Option 2. Option 2 would be preferred. I have about 600 pages of data in this format. Any help would be appreciated.

Image that shows examples: https://drive.google.com/file/d/0Bx9...ew?usp=sharing

Is there a way through formulas or vba to easily transpose the data in column C vertically on a separate sheet so that it would create a proper data file?