I have a column with about 400 cells consisting from five to ten names. I'd like to display in a separate column all of those names once, and if possible, in a particular order, such as alphabetically.

EXAMPLE
A
1 Smith
2 Smith
3 Johnson
4 Davis
5 Johnson
6 Davis

FARMED

A
1 Davis
2 Johnson
3 Smith

And could this be done to be automatically updating, or would it only be a one-time function?

Thanks for your help!