Delete Duplicates

To pick an example, A3 contains some text (Gerard), and A4 contains the same text followed by a line feed.

Ditto for A2 and A5, and other apparent duplicates.

Assuming none of those belong, select the entire range and do Ctrl+H. In the Find box, press and hold the Alt key, and on the NUMERIC keypad, enter 0010

Leave the Replace box blank, and press Replace All.