I have a table with a large number of customer ID's in column A and associated customer data in columns to the right.
10 to 15 columns will contain phone numbers. The problem is the same phone number will appear in more than one column.
I would like to delete the duplicates keeping just the first occurrence of the number. (closest to column A).
All of the columns have labels and columns containing phone numbers have "Phone" somewhere in the label. (the column order changes sometimes so I can't specify by column number)
Any help greatly appreciated!! (sample data attached)