Hi,

I have a dataset which has multiple columns. Each column is a collection of names of individuals seen on a specific date. I need to remove duplicate names for each date. At this stage I am just going removing duplicates column by column but there has to be a faster way. As I have over 400 columns in each workbook its rather time consuming.

Example
1 2 1 2
Nick Nick Nick Nick
Jane Nick Jane John
John John John Sam
John John Sam
Sam Sam

Thanks for any ideas