Hi,

I am working on a spreadsheet where there is a list of unique store codes (500+) and a list of unique product codes (300+). I need to populate and regularly refresh a list of all combinations of the store and products. Can anyone help me work out a way to do this, please?

For example:

Column 1 - Column 2
Store 1 - Product 1
Store 1 - Product 2
Store 1 - Product 3
Store 1 - Product 4
Store 1 - Product 5 etc.
Store 2 - Product 1
Store 2 - Product 2
Store 2 - Product 3
Store 2 - Product 4
Store 2 - Product 5 etc.

Thanks in advance for your help.