I have a big excel file with 5000 rows and 20 columns. I want to extract specific rows and save it in another worksheet. Following is a simple example of what output should be
Suppose the excel contains following data
HTML Code:
1 abc
1 cde
1 efg
2 hij
2 lkp
2 jkl
3 opl
4 lkp
4 pol
5 lkm
6 plm
6 dfb
I want to extract the following rows
HTML Code:
1 abc
2 hij
3 opl
4 lkp
5 lkm
6 plm
Can you please help me?