Data Table Reorganizing Question

[Dynamo418]

Hi guys,

I have attached a spreadsheet to show what I'm talking about. Basically, I am combining (up to 4) data sheets into one document, and am looking to reformat using VBA.

The first tab 'Initial Data Format' is the starting point. This says whether a program should be sent to Large stores, Medium stores, or Small stores for each month. In the example I am pulling in information from 3 quarters. Some of the programs from the 2nd and 3rd quarters overlap with the programs from the 1st/2nd quarters. In these situations, I want to combine the information. Ultimately, only unique programs should have their own row, and there should only be one row for dates along the top. 'N/A' is reserved for programs that do not exist for that time period.

This is shown in the 'Desired Data Format' Tab. I am looking for a VBA solution given that I am working with large amounts of data (so I cannot have separate dump tabs with vlookup formulas due to the complexity).

Is this possible??? It would be a huge benefit for my organization if we could do this!

Cheers!!