Automatically appending two tables of data into a third table

Hi,

What I am trying to do is to automatically merge two tables of data i.e. Table 1 & Table 2 into Table 3.

i.e. Table 1 & Table 2 have a maximum of 10 rows of data each and Table 3 is a table with 20 rows. My problem is I need to automatically appended Table 1 & Table 2 into Table 3, however either Table (1 or 2) may or may not have their 10 rows of data completed but I want Table 3 to be one continuous table of data (please see attached file for example).

Ideally I would prefer a formula as opposed to macro code or VBA but I would appreciate any potential solution.

Any assistance in this matter would be greatly appreciated

Many thanks in advance

Bob

Excel Version 2003

With the addition of a key column with formulas, this become a simple index/match function.

JBeaucaire

Many thanks for your prompt reply it us very much appreciated.

You coded worked really well until I entered text into the first column of Table 1 & Table 2 resulting in your formula in column ‘F’ (Key) change to “#VALUE!”.

Any idea how to amend your code to accommodate text in any of the columns in Table 1 & Table 2

Regards


Rob

Change this:

=IF(C6<>"", N(F5)+1, N(F5))

JBeaucaire.

I've changed the formula and it seem to have messed Table 3 up completely

I've attached the file and would really appreciate it if you could take a look


Regards


Rob

You didn't notice the formula in F18 and F19 aren't adjacent. In F19:

=IF(C19<>"",N(F18)+1,N(F18))

JBeaucaire

I can see where I went wrong - Many thanks

I've made a note to myself to check if ever I insert extra rows as it could cause the formulas to be thrown out of synch.

For others to benefit from the code I have uploaded the working file

Once again many thanks for all your time and effort it is very much appreciated


Best regards

Rob

JBeaucaire

I can see where I went wrong - Many thanks

I've made a note to myself to check if ever I insert extra rows as it could cause the formulas to be thrown out of synch.

For others to benefit from your code I have uploaded the working file

Once again many thanks for all your time and effort it is very much appreciated


Best regards

Rob