How could I generate every possible question/answer combination?
Posted on 2013-11-19
I need to generate a list showing every possible combination of answers to several questions.
Each row in this list should be another possible combination of answers.
For example, there might be two questions (question 1 & question 2), question 1 has two possible responses (a or b), question 2 has three possible response (a, b, or c). Below is the kind of list I need showing each possible combination on a separate row:
In Excel or Access or some other common tool, I'd like to specify the number of questions & number of answers for each question & get a list or table like the one above. Is this possible using VBA or something else available via MS Office or on the web?