Auto Name Compiling and Sorting

Hi All

Please help me again on my problem. I need to compile names from 2014 - 2015 and come up a list that duplicate names are remove from the list. and the final list of names should be in column C.

Thanks.

Please see attachment for ref.