I created two tables with 100' of addresses and would like to merge them in one

Is this task possible …

Of course you can. Before you start, make copies of your files. It does not matter if it’s two spreadsheets or two tables. Of course, the tables should have the same number of columns with the same headings and in the same order.

Example:

  • Open both tables. From Table 2, mark all addresses (without a heading).
  • Copy them ( Ctrl+C ).
  • Go to Table One.
  • Put the cursor in the left column after the last address below and paste the addresses from table two ( Ctrl+V ).

You can now mark the entire area in Table 1 and sort according to your wishes.

Please do not forget to save! Maybe give the file a new name.

I wish you success!