Hey everyone, I’d like to merge some records and retain anything linked.
I have a table with companies and a table with agents. Some of the companies have more than one entry due to spelling errors or variances in formatting. I’d like to combine these records but retain the agents that are linked, and any other linked records or information.
For example, in my companies table, I have “Clarence” and “Clarance”. They are both the same company and should be one record. A new record was created due to a spelling error. These companies have different agents linked to them, but I’d like them all to fall under the same company name in one record.
Is this possible? Any help would be much appreciated. I’ve looking in other threads and online but haven’t been able to find a definitive answer. Thank you