I have a spreadsheet that looks something like this:
Full Name | Email | Phone Number --------- ------- ----------- Billy Bob firstname.lastname@example.org 8019929102 Sally Sue email@example.com 8013439403 Billy Bob 8013432343 firstname.lastname@example.org Sally Sue Joe So email@example.com
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.