Google Sheets has a really handy feature called Remove duplicates, which can be found by clicking on Data → Remove duplicates from the menu bar. In a nutshell, here's how it works:
- Highlight the range of cells you'd like de-duplicated
- With your cells highlighted, click Data → Remove duplicates
- Select your settings, and click Remove duplicates
For example, here's what the setup would look like if you wanted to de-duplicate the Country field in our Users tab:
Highlighting a single field (e.g. as shown above with the Country field) will remove duplicate cells. Highlighting multiple fields (e.g. Country and Acquisition Source) will remove duplicate rows. As in, the entire row of your selection is scanned and compared against the others.