how do I find and sort unique values from a column

[Guest]

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?

 

[David Biddulph]

Adavanced Filter/ Unique records only, then sort.