get unique list in numbers

Starting with, say, something like this:

You can Organize > Show Filter options and Add a Filter... like this:

Then if you need the results elsewhere you can copy the visible cells, click once in the cell of an existing recipient table, and command-v to paste.

SG