I have to columns, alphabetically sorted, one with 1oo names, one with 8o-9o
names, which are identical to the ones in the column with 1oo.

Is there a way (formula or macro) that places the identical text (names)
next to each other in the same row, leaving blank the cell where there is no
match?

The columns should then look like this:

Miller Miller
Smith
Kerry Kerry
Ferguson Ferguson
Peters
Black Black

etc.


Thank you