Automating table transformations

I have two tables that I want to combine.
rating.jpg

The expansion of the table should look like this by the end (this is a cut off version as it's quite large)
Untitled.jpg

My idea is to loop through the blue range. On each cell I want to record the corresponding values for the variables Meal, Course, Fruit, Letter, and Pies. Then it would be a case of writing the table one line at a time as they are recorded. Since I have two ranges of the same structure I guess I'd have to do it twice.

I'm fairly new to programming so I'm not really sure how to get started with this.

I have written the first bit which unmerges the cells and fills in them with the corresponding values. Like so

Please Login or Register  to view this content.

Untitled2.jpg

The next stage would be to copy any column with a "/" in to the end of the table. Finally I need to loop through the values of the range recording the corresponding values that I need.

Any help getting started would be greatly appreciated.

Posting that sample workbook would help, and this definitely is doable. Per the Forum's tips for getting a quick answer:

Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.