I need to work out a way to handle duplicates when I import for the migration form our old system. How would you guys handle something like this?
I have contracts and contacts but with our old system we had to duplicate the contact if they had multiple contracts as we couldn’t assign multiple contracts to a contact.
I have an excel spreadsheet of all the data but I need to find a way to combine the contacts to one ID. So John Smith would have 2 rows in the spreadsheet with the ID 123 but keeping the contract IDs