Excel return cell without duplicates

I have a column that uses the LOOKUP function to pull a list of names from a separate sheet within the same workbook. The list of names is concatenated using an IF function - the list is in a single cell; names are separated by commas; and some names repeat.

Is there a function that can be applied or some other excel magic that can return this list of names without duplicates?

e.g. I have a table of company names in one column and account managers in another column - the LOOKUP function pulls the list of all account managers associated with that company into one cell with names separated by commas. For example, currently, the account managers shown for "Google" (A2) are "Bob, Joe, Bob, Tom, Bob" (B2), but I would like for it to only show "Bob, Joe, Tom".