Hi,

If I have a list with numerous items, most of which are repeated a number of
times, how can I create a list that shows each item in the larger list once?

For example,

from this list:
John
John
John
James
James
Tom
Tom
Tom
Tom

I'd like to get:
John
James
Tom

Is there an easier way of doing this than creating a pivot table, or using
subtotals?

Thanks,
Jason