Hello!
I have two tables of data ~2000 rows each, with mostly intersecting full names. I would like to align these two tables by full names to make a combined third table. Please see an example. I want from tables 1 and 2 to make a combined table 3.
I have two tables of data ~2000 rows each, with mostly intersecting full names. I would like to align these two tables by full names to make a combined third table. Please see an example. I want from tables 1 and 2 to make a combined table 3.
| !Combined.xlsm | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | TABLE 1 | TABLE 2 | ||||||||
| 2 | ||||||||||
| 3 | Full Name | Company | Other | Full Name | Phone | Other | ||||
| 4 | Alec Black | ablack@example.com | A | … | Alec Black | 111 | … | |||
| 5 | Ben White | bwhite@example.com | B | … | Cheryl Smith | 222 | … | |||
| 6 | Cheryl Smith | csmith@example.com | C | … | Florence Night | 333 | … | |||
| 7 | David Bowie | dbowie@example.com | D | … | Stewart Long | 444 | … | |||
| 8 | Edward Nice | enice@example.com | E | … | ||||||
| 9 | Florence Night | fnight@example.com | F | … | ||||||
| 10 | ||||||||||
| 11 | ||||||||||
| 12 | TABLE 3 | |||||||||
| 13 | ||||||||||
| 14 | Full Name | Company | Other | Full Name | Phone | Other | ||||
| 15 | Alec Black | ablack@example.com | A | … | Alec Black | 111 | … | |||
| 16 | Ben White | bwhite@example.com | B | … | ||||||
| 17 | Cheryl Smith | csmith@example.com | C | … | Cheryl Smith | 222 | … | |||
| 18 | David Bowie | dbowie@example.com | D | … | ||||||
| 19 | Edward Nice | enice@example.com | E | … | ||||||
| 20 | Florence Night | fnight@example.com | F | … | Florence Night | 333 | … | |||
| 21 | Stewart Long | 444 | … | |||||||
Sheet1 | ||||||||||
