Microsoft Excel: Remove Duplicate Address but Keep Names

Have an Excel list with about 7623 names and addresses. However most of those addresses are duplicates because of multiple people living at the address. I want to remove the duplicate addresses but keep the names of the individuals living in the home in the first name column only, leaving the last name column blank.

Eg:
John Smith, 123 Smith Road
Vernon Johnson, 123 Smith Road
James Adams, 123 Smith Road

John Smith
Vernon Johnson
James Adams
123 Smith Road