Enrich Company Data Efficiently: Eliminate Duplicate Domains in One Table through Smart Sorting & Enrichment Strategy

Hey! I'm always working with a Small TAM, so there will be a lot of duplicate domains (different person) in my tables. How could I enrich a company based on their LinkedIn profile in a way, that I only do it once for a company, not multiple times for the same companies within one table. I'd need to sort the table so one domain/profile is visible, then enrich. After done, I'd add the results for the duplicate domains/profiles. Any way to do this?