Concatenate single instance of duplicates

Hi,

run a formula like

=A1&" "&B1 and copy down (adjust cell addresses first), then use the Remove duplicates command on the Data ribbon.

hth