I have a dataset with duplicate names, yet same IDs. It looks like this. I received this dataset as is, so not sure why the names are case sensitive. ID FirstName LastName 001 John Reed 001 JOHN REED 002 Mitchel James 003 Steph Ania 004 King Mon 004 KING MON 005 Valery Short 012 ALMA JACOBS 012 Alma Jacobs 017 Josh Ryan 017 Jash Ryan I need to identify those with the exact same spelling for firstname and lastname variables to remove the duplicates. I want the final dataset to look like this table below. However, given that I have around 800 rows and the names are duplicates due to being case sensitive (except for ID 017, which is a duplicate due to a typo), I'm unsure of how to approach this. Does anyone have any suggestions and/or solutions? ID FirstName LastName 001 John Reed 002 Mitchel James 003 Steph Ania 004 King Mon 005 Valery Short 012 Alma Jacobs 017 Josh Ryan 017 Jash Ryan
... View more