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
|