Remove Duplicate Rows Based on One Column in Google Sheets

When you're using Google Sheets to keep track of a contact list or sign-ups, sometimes the same name or email can show up more than once. It happens a lot and you can get rid of this situation ...