Preprocessing of Raw data

Need help in cleaning data from two concatenated columns, first column is mixed names of companies and people names and second one is of all people names. I have to clean first column with reference to second column. End result expected is first column only of company names and all people's name match second column is removed....Please suggest

Can you please post a simple reprex. Hard to say what you need without seeing your data and your best attempt so far.

1 Like