I am trying to align rows of two different tables in a column so that absent rows appear as blank rows on each of the tables. So for example, if I have the following tables:

```
A 4 9 A 4 8
B 3 7 C 3 9
D 4 2 E 7 2
F 4 2 and F 1 3
```

And I want it to show me which columns are common on the first field and which aren't, my resulting tables should look like:

```
A 4 9 A 4 8
B 3 7
C 3 9
D 4 2
E 7 2
F 4 2 and F 1 3
```

How can I achieve this with Excel?

Ted