I have three columns of data as follows:

A = Plant name
B = 1st Party test
C = 2nd Party test

Sometimes there will be a duplicate plant entry because there is data from
col b and c.

I need to be able to remove the duplicate plant name and move the associated
col c data to the row of the original plant name.

Thanks.