I have inherited a spreadsheet which has lots of duplicated rows. However,
some information is missing for certain fields. For example one row will
list:
Firstname (Jim), Lastname (Jones), Phone (1213111) and the duplicate will
just have say the Firstname (Jim) & Lastname (Jones).

What I would like to do is remove the second record from the spread sheet.
There are many instances of this throughout.
Is there a way that this can be achieved?

Thanks for any help