Delete Same type name from different cells except one.

[bimalendu.pollutech]

Hi,
i have a sheet containg with same type name in different cells of column, i have to delete all the same type name except one cell, please advice.