how do I find and sort unique values from a column

S

spreadsheet monkey

hi,

I have a list of n number of values (i.e names and ID numbers). each unique
value will have several entries (i.e the same ID number and name will exist
multiple times)
I want to sort the data so that the remains will be a single entry per
unique value (i.e every name only pops up once)

how do I do it?
 
Top