E
eric
I have 20,000 rows and five columns in which I need to compare the
contents of all the cells in one row, remove (text) duplicates from
those cells and merge them into a new cell along the same row with the
data separated by commas. When I did not have duplicates and I merged
the cells, I ended up with mulitiple commas and ,,Cell3,, in the new
cell. I do not want the extra commas.
contents of all the cells in one row, remove (text) duplicates from
those cells and merge them into a new cell along the same row with the
data separated by commas. When I did not have duplicates and I merged
the cells, I ended up with mulitiple commas and ,,Cell3,, in the new
cell. I do not want the extra commas.