HI,
The webpage I’m scrapping has 49 values. and it spans across 10 pages. after scrapping values to excel I’ve 2 extra rows in below format—
For 1st page Data row 1 to 51 (with header)
then row 52,53 extra rows
then for 2nd page Data row 54 to 103
then row 104,105 extra rows
and so on…
I need to remove extra rows for 10 pages… can anyone help how to do this?