Populate columns in one sheet based off of a few lists in a different sheet

Hi,

This is my first post. However, I'm a longtime viewer.

I've spent quite some time trying to figure out the best way to approach my Excel problem.

The objective:

I would like to take at least 2 lists in a "Setup" sheet (it could be more lists later) and have them 'auto populate' cells in other columns in another sheet, "Results"(same workbook).

Example:

One list would have a number of questions (like a survey - for example, they are formated Q1_1_1, Q1_2_1, etc) and the other list would be of countries (for example, Brazil, India, China, Chile, etc). I need the list of questions to populate one column of the "Results" sheet. It would need to do that for every country listed in "Setup". I also need it to 'auto populate' the country in the column next to the questions in the "Results" sheet. It would be replicating the same list over and over for each country listed.

I want the users to be able to paste in their long list of questions in one column in "Setup" and their list of countries in another column, also in "Setup". That way the "Results" sheet columns will auto populate everytime with the appropriate questions and countries. Its important to note that the number of questions and the tags assigned to the questions can change. The list of countries will also be changing.

I know the quick and easy way is to simply copy and paste the list of questions and drag the countries down. But I'm convinced Excel can do this for me - I don't want people getting lazy or tired and messing things up.

If I have broken any forumn rules, please know that I did not intend to. Thank you for your help!!

Jim