Hi all, I need some help. I have a 2000+ row datasheet.
Each row has a number as the first column. Many of the numbers are repeated and I only need to have one row of each with that specific number. Obviously i can go through and delete all the rows after sorting, however, after 30 minutes of this, I am blearly eyed. Any suggestions? How do i run something that will that leave one row with that specific number:
For example, the way it is now....
1234 BobBob abcdefg
1234 bobbob abcdefg
3241 johnjohn abcdefg
3241
3241
3241
2542
2542
Each row has a number as the first column. Many of the numbers are repeated and I only need to have one row of each with that specific number. Obviously i can go through and delete all the rows after sorting, however, after 30 minutes of this, I am blearly eyed. Any suggestions? How do i run something that will that leave one row with that specific number:
For example, the way it is now....
1234 BobBob abcdefg
1234 bobbob abcdefg
3241 johnjohn abcdefg
3241
3241
3241
2542
2542