Thanks -- the tables are not in one document (but I can, of course, copy them into one document if it is easier then to merge them).

There is, unfortunately, no certain character separating the country from the rest of the text (that's why I came up with the 13 characters - but that should not be a problem in VBA to see if the first 13 characters of two cells match...).

Merging and sorting as you suggested does not work, unfortunately, because this would mean that I still have 4 columns... As I said, I would like to have 8 columns afterwards:

"...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)"

So it is actually as easy as I said:

- checking if we have a match in column 1 (first 13 characters)
- if yes: putting column by column from each table
- if no: putting column by column but leaving the cells of that table blank which did not have the country...

Can anybody code this?

Thank you.

Best,

Fin