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!