I have a spreadsheet that looks something like this:
Full Name | Email | Phone Number --------- ------- ----------- Billy Bob email@example.com 8019929102 Sally Sue firstname.lastname@example.org 8013439403 Billy Bob 8013432343 email@example.com Sally Sue Joe So firstname.lastname@example.org
I want to remove duplicates based on email and keep the row that has the most complete data (the most columns filled). After I do email i'll look for duplicates based on Full Name and then phone number etc..
This is going to be done on almost 500,000 rows of data.