Deciding how to remove duplicates in an Excel table with people who have the same name

Since two names are listed, you delete one. While this operation seems simple in a roster, if they are different people, you ...