Sorry for the terrible title but I couldn't put into words exactly what I'm looking for. Basically I want to generate a list of names omitting the repeats. For example:

\1

I would like column F to list the vendors in column A. Since there are multiple A I would only like it listed once. This will be used to track expenses and there will be several payments for the same vendor and I want the total.