How to put these two sets of data together for adwords

I have a Google Adwords campaign with around 200 ad groups. I would like to add some keywords which follow a similar structure to each ad group. They will be like this:

*standard keyword text 1* + location 1
*standard keyword text 2* + location 1
*standard keyword text 3* + location 1
*standard keyword text 1* + location 2
*standard keyword text 2* + location 2
*standard keyword text 3* + location 2
*standard keyword text 1* + location 3
*standard keyword text 2* + location 3
*standard keyword text 3* + location 3
etc

If I would like to add more keywords after I have initially done this, in the future I will probably want to add more keywords to each location so it may go like this:

*standard keyword text 1* + location 1
*standard keyword text 2* + location 1
*standard keyword text 3* + location 1
*standard keyword text 4* + location 1
*standard keyword text 1* + location 2
*standard keyword text 2* + location 2
*standard keyword text 3* + location 2
*standard keyword text 4* + location 2
*standard keyword text 1* + location 3
*standard keyword text 2* + location 3
*standard keyword text 3* + location 3
*standard keyword text 4* + location 3

Does anyone know how I can construct a spreadsheet to help me do this quickly and easily? Is it even possible?

Here's a simple macro enabled sheet I use.