Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Thanks for your answer CEAuke. Unfortunately it's not working. I'll try to give a better description.

For example:

Table1 contains 10 entries (from 1-10) with ID, name and address Table2 contains only 5 entries (2,3,5,7,9) with the same data as in table 1 plus an extra column with age

In table2 the entire entries for 1,4,6,8,10 (including the ID) are missing. Now I want to merge the age column into table1. If I try to do this I get problems, because A2 in sheet1 differs from A2 in sheet2.

Hopefully this description is more precise.

is merging those two sets possible at all?

Thanks for your answer CEAuke. Unfortunately it's not working. I'll try to give a better description.

For example:

Table1 contains 10 entries (from 1-10) with ID, name and address

Table2 contains only 5 entries (2,3,5,7,9) with the same data as in table 1 plus an extra column with age

In table2 the entire entries for 1,4,6,8,10 (including the ID) are missing. Now I want to merge the age column into table1. If I try to do this I get problems, because A2 in sheet1 differs from A2 in sheet2.

Hopefully this description is more precise.

is merging those two sets possible at all?