I have a list of 4,000 voters
Column C has the voter names
Column D has the voter addresses
On average we know there are just over 2 people per address in this area so there are a 4,000 different names in C and 2,000 different addresses in D
As I am only interested in the number of houses to leaflet and want to geocode and map them what I really want is just the list of 2,000 addresses in column D with one line per address
e.g. at the moment I have
John Smith 1 Acacia Avenue
Jane Smith 1 Acacia Avenue
Fred Jones 2 Acacia Avenue
and so on down to line 4000
What I want is just:
1 Acacia Avenue
2 Acacia Avenue
and so on down to line 2000 or whatever
Wracked my brains but can't think of a way to do this.
Bookmarks