I have a spreadsheet that looks something like this:
Full Name | Email | Phone Number
--------- ------- -----------
Billy Bob [email protected] 8019929102
Sally Sue [email protected] 8013439403
Billy Bob 8013432343
[email protected]
Sally Sue
Joe So [email protected]
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.
Phone Number
is correct for Billy Bob?!?