Dear all

Could you please help me with this scenario?

I have two tables in WORD which I want to merge in the way described below. For ease of reference, I am calling the tables "TABLE 1" and "TABLE 2".

About the tables:

• Tables 1 and 2 each have four columns.

• The first column in each table contains a country in each cell plus some other text behind them (i.e. in the same cell in the first column).

• There are some countries (plus text) in table 1 which are not in table 2 and some in table 2 which are not in table 1.

About the intended merging of the tables:

• I would now like to go through all the rows in each table and if the first 13 letters of the countries in column 1 of each table match, then I would like to put column 1 of table 1, then column 1 of table 2, then column 2 of table 1, then column 2 of table 2, etc. (until all columns are next to each other, i.e. until column 4 of both tables).

• If the first 13 letters do not match I would like to still display the row and then leave the cell for the table which does not have this entry blank.

Thank you very much for your help!!

By the way: I picked 13 letters to identify the countries because there are no double entries then (and I do not have another possibility to identify them because the cells with the countries have a lot of other (varying) text so that I cannot just look for identical cells in tables 1 and 2).

Best

Fin