I have a column of data and i would like to remove the repeats in the same
column or maybe with a helper column. See below:

Example:

ColumnA ColumnB

John Doe John Doe
John Doe
Kim Smith Kim Smith
Kim Smith
Kim Smith
Kim Smith
Dav Hodge Dav Hodge
Dave Hodge

Thanks.