Mixing Blocks of Data from 2 Columns into 1 Column, with conditions

Hello all you Excel Gurus! I'm currently stumped on this particular subject/problem. Basically I have two columns of data that I want to inter-mix to produce just one column that contains the data from the other two. There are conditions on how I would need them to be mixed and these conditions can change. I've attached a basic/generic outline of how the data would look as entered, along with the what the desired outcome should look like under Column H. If this is something that should be done with macros, I would greatly appreciate the re-direct, albeit I have little to no knowledge on how to create a macro, which is why I'm pulling my hair out trying to shoehorn a formula.

In other words I have one column (E) that has numbers that indicate the number of cells that should be copied and block-intermixed from two other columns (F & G) under a single column (H).

I figure a bunch of IF functions embedded within each other would work, however due to the variable nature of the conditions that the block mixing is dependent on, I'm not sure how I should account for the different possible scenarios.

With regards to the workbook, the variables that are the most important are under columns D/E; these columns denoting the # of sub-sets will determine the number of consecutive cells that should be returned from column F, then column G, before returning to Column F to start with the next sub-set.

I apologize in advance if my question is unclear.

Hi

I've had a go ata macro to solve this problem (couldn't see an easy formula option, but I hope someone comes up with one for you).

The macro code is:

Please Login or Register  to view this content.

I've tried to include some notes to make it easier to understand. Hope this helps.

Cheers, Rob.