Hello,
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.