View Single Post
  #1   Report Post  
RMN RMN is offline
Junior Member
 
Posts: 3
Question Deleting duplicates within a column?

If I have, for example:

4,2,,3,2,,,,,,9,9
6,44,,,,,,9,12,6
ee,3,22,22,22,22

and I want to delete the duplicate numbers and commas so that it looks like:

4,2,3,9
6,44,9,12
ee,3,22


Is there a way to do this and apply it to an entire column? There are nearly 10,000 rows in this column and they are all different, so it will be very time-consuming to do it by hand.

Thanks a lot! :D