Vb code or Excel formula Help for unique rows

hello,
i have a list of 5775 rows ,what i need is to get unique rows from this list.every string must be used only once no repeat.the final result is going to be 165 unique rows.like in example
in the attachment.
so is there any excel formula or Vb code to solve this?
thanks in advace for any help.
SEM