Remove duplicates from a row?

cabbsman

Is there a way to remove duplicate zip codes in a row of columns so only unique zip codes will be available when I concatenate them all into a combined zip code column?

Example: If I have 4 columns of zip codes and Col 1 and Col 4 are duplicates, I only want to show Col 1's Zip Code once when I combined all the columns into Col 5.

Where the result in Col 5 would be a concatenation of all zip codes on the same row with only one zip code instance of 95973 listed.

John Shane

@cabbsman

A JOIN(DISTINCT()) function should work for your needs.

=JOIN(DISTINCT([Col 1]@row:[Col 4]@row), ", ")

Cheers,

John

John Shane

@cabbsman

A JOIN(DISTINCT()) function should work for your needs.

=JOIN(DISTINCT([Col 1]@row:[Col 4]@row), ", ")

Cheers,

John

cabbsman

Well, that did it! Thank you!!!

John Shane

You're welcome. Glad to be of assistance.