Consolidate names in a column

[raymaster98]

Using Excel 2010.

In column C, I have a list of names. Many of the names are repeated in the column. In another column, I am looking for a formula to consolidate the names without name duplication. Any help would be appreciated. Thanks, Kenny

 

[VoG]

Select the data, on the Data tab in the Sort & Filter group click Advanced, check Copy to another location and Unique records only, select the destination range and click OK.

 

[raymaster98]

Perfect! Thanks so much for your help