Hello, I have a spreadsheet that contains phone numbers that I need to consolidate.
I have attached an example of the data I am working with here: Spreadsheet: phone_number_cleanup_example.ods
As you can see, multiple columns contain the same values, within the same row. I need to consolidate this list and remove all the duplicates WITHIN THE SAME ROW. For example, cells C2 and D2 contain the same phone number. I need to remove one of these.
I do NOT need to remove duplicates within the entire spreadsheet. For example, cells D2 and H7 contain the same phone number, but are not in the same row and therefore are not considered duplicates, for my purposes.
I have searched for macros, extensions, formulas, etc. to no avail. I am a computer programmer but am fairly inexperienced when it comes to spreadsheets. Any help is GREATLY APPRECIATED!
(Edit: activated screenshot -AK)