Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

how to merge two tables with incomplete data


I'd like to merge to tables, which one of them has only a limit data set.

For example:

Table1: ID (1,2,3,4,5), name, address

Table2: ID (2,3,5), name, address, age

Is it possible to combine the data in one table. My attempts with vlookup and index-match are falling, because of the incomplete data set in table2. I tried it with Base and Calc, but without luck. If anyone has a solution either in Calc or Base I would really appreciate it.

thanks in advance.