Combine two lists in Excel, one underneath the other

I have two lists of products in Excel. Each list will be of varying length each month.

Is there a way to combine the two lists into a third list, with the second list being underneath the first?

I would like to do this avoiding macros.

I image this could be done using Dynamic Arrays, but I can't figure it out.

Please see an example below:

Thank you so much in advance.

I have managed to find a solution that works for me, where the lists are of variable length.

Using a similar scenario to Mardi-Louise's answer, I am using the following formula in cell F3, and then dragging down:

=IF(B3<>"",B3,OFFSET($D$3,ROW()-COUNTA($B$3:$B$7),0))

Explanation:

• So long as List 1 is not finished, it takes the value from List 1.
• Once List 1 is finished, it begins at the top of List 2, and uses an offset to move down.