Our entire workflow hinges on quick and easy mass-merging of records based on simple rules:
When the Email keys of two records match create a single record out of both:
Ignore empty fields
When available, select the more recent entry to a field
This is because we plan on sending follow-up surveys to people in the database, and updating their records w/ updated answers or new columns.
Also, at the scale we’re planning, it’s simply not workable for us to go record-by-record and manually figure out which fields are newer. So, ideally this could be done for the entire database with a click of the button—or even automatically as new rows are added to the database.