I have a list of street addresses and want to create a list of street addresses without any duplicate address show for instance in this example
I want to turn column A into Column B
I want to turn column A into Column B
COLUMN A | COLUMN B |
ADAMS ST | ADAMS ST |
ADAMS ST | ALBERT AVE |
ADAMS ST | ALMONT AVE |
ALBERT AVE | |
ALMONT ST | |
ALMONT ST | |
ALMONT ST |