Hi,
I have problem Please look at the picture below:
In this picture you can each url ending with pagenum=1
There are 29670 rows in excel sheet and all ending with pagenum=1
And also you can see the zip code which is "Ab10" for all 29670 rows.
WHAT I AM LOOKING FOR A FUNCTION THAT WILL REPLACE EACH ZIP CODE AFTER 10 ROWS AND add PAGENUM=1-10
For example First zip code is AB10 so i want first 10 rows like this and then next zip code is "ab11" and so on for all zip codes. Check image below for better understanding.
So the gap is 10 rows. After each 10 rows the ab10 should be replaced with next zip code and the pagenum should add 10 pages.
E.g
Pagenum=1
Pagenum=2
Pagenum=3
and so on.. for each 10 rows.
I have a list of zip codes already. Please Help me if it is possible to do. Thank you in advance
I have problem Please look at the picture below:

In this picture you can each url ending with pagenum=1
There are 29670 rows in excel sheet and all ending with pagenum=1
And also you can see the zip code which is "Ab10" for all 29670 rows.
WHAT I AM LOOKING FOR A FUNCTION THAT WILL REPLACE EACH ZIP CODE AFTER 10 ROWS AND add PAGENUM=1-10
For example First zip code is AB10 so i want first 10 rows like this and then next zip code is "ab11" and so on for all zip codes. Check image below for better understanding.

So the gap is 10 rows. After each 10 rows the ab10 should be replaced with next zip code and the pagenum should add 10 pages.
E.g
Pagenum=1
Pagenum=2
Pagenum=3
and so on.. for each 10 rows.
I have a list of zip codes already. Please Help me if it is possible to do. Thank you in advance