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 |