I am looking for a way to take a list of values from one column, and in
another column display a list of distinct items in this list.

So if in column A I have the following values:
Alan
Bob
Charlie
Alan
Alan
Alan
Charlie
Dave
Charlie
Bob
Edgar
Bob
Bob

In column B (or another worksheet or whatever) I am expecting a list like
this:
Alan
Bob
Charlie
Dave
Edgar

Is there a way to do something like this?

Thanks,

Cindi