I have a long list of data that is, on some, rows duplicated. Is it possible
to merge these lines without going through every row and deleting manually. I
tried the search and find function but I have to input each piece of data
manually.
There is about 600 rows and two columns, the first column is a surname and
the second column is a ref no. Some of the surnames and ref no's are
duplicated. I want to delete the duplicated ones is there a way

Thanks
--
xxx888xxxx