I would like to make a new column that has already removed the duplicates from the previous column

ex)

Greg
Kevin
Todd
Kevin

The new column should have

Greg
Kevin
Todd

The problem is that I want it automatically do this when I add a new name to the list. I don't want to hit the filter each time because I will often be adding to this list.

Any ideas?