I am trying to find an easier way to copy hundreds/thousands of columns containing many duplicate names

Example:

Boston
Boston
Boston
Boston
New York
New York
New York
Chicago
LA
LA
LA
LA
LA
Chicago
Chicago
Boston
Boston


The only way I can do this is by using the Advanced Filter option, but I am pretty sure there used to be a way to use Paste Special and select unique values only. Is there a better way to do this?