Third Post - Problem Still not solved - Function needed

[Abbas999]

Hi Experts, THis is my third post regarding the same issue.

I have a list of 29670 URLS in a Excel Sheet.
Example URL -

keywords=clubs&location=Ab10&searchType=manualexpansion&autocomplete=kw_recent&scrambleSeed=981534963&pageNum=1 In this URL Zip code is "Ab10" Same for all 29670 URLS. You can see that all urls ending with same text "pageNum=1"

<tbody>
</tbody>

I have a list of 2967 Zip Codes. I want Each Zip Code replaced with 10 URL's.
That means - First rows will contain zip code "Ab10" and It will ends with pagination like pagenum=1, pagenum=2 and so on for each 10 rows.
next 10 rows will have a zip code Ab11 and same 10 pages pagination.

REMEMBER that Zip codes are A to Z. Not just ab10, ab11, ab12. They a list then B list then C and till Z.
URL are 29670 and Zip codes are 2967

2967 x 10 = 29670

Each ten rows = 1 Zip Code. and Pagination 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

Please I tried my best to explain my problem. Please Help me solving this issue. Thank you

 

[Smitty]

Please stick to your Original Thread.

Creating duplicates just confuses people and creates additional work for everyone.