When importing data, if the item already exists, the original data will be wiped out if there’s new information in the same column. Ex: Mr. A already exists and there’s information in Notes column. If we want to update the Notes column through an import (because there are hundreds of items that need to be updated), the original information in Mr. A’s Notes column is wiped out and replaced with new information. Much better is to have the information in the column truly merged. We are always adding names of attendees to conferences, but often the same people will be on both the Monday (existing) list and the ones we’re importing. We want to add new information but not wipe out the original. Would save hours and hours of de-duping time.
You can use the Duplicates and Uniques app for this.
Here is a demo of how the merge functionality works.
In your case, for the “Notes” column, you can select the option to join and how to join, for example, using a comma as shown in the screenshot.
