Hi, so I was sent an address list with names by one of my friends. It's approximately around 1800 and I wanted to group them like:
Name Adress John Smith 123 Alpha Ave John Smith ]321 Bravo Rd Jane Doe 156 Charlie Fwy Jane Doe 57 Delta St
Because how it looks like right now is:
Address Name John Smith 123 Alpha Ave Jane Doe 156 Charlie Fwy John Smith 321 Bravo Rd Jane Doe 57 Delta St
In short, I wanted a list from wherein it would group the addresses under the same name so that it would be less time consuming when I started inputting the numbers. Because I've checked for duplicate names and there's a lot but has different addresses. If that made any sense, apologies English is not my first language. Any help would be appreciated, Thanks!
Bookmarks