First of all I don't have experience with Excel scripting, just basic formulas. I've seen this other question on SU but I'm not sure if that's exactly what I need or how to adapt it to my needs.
Here's what I'm trying:
I have a spreadsheet with 3 columns and 10 rows, each of them having unique values. For example:
Column A
--------
White
Black
Blue
etc (until 10 items)
Column B
--------
USA
Canada
Mexico
etc (until 10 items)
Column C
--------
English
French
Spanish
etc (until 10 items)
So in total there are 30 elements. I would like to create a new table with those 3 Columns and 1000 rows, where each row would have a unique combination of those 3 elements (so 2 rows will never have the same 3 elements). Just for clarification, the order of the Columns has to be the same (A, B, C) and of course elements of one column always stay in that column.
Examples of resulting rows:
White | USA | English
White | USA | French
Black | USA | English
Black | Canada | English
... up to 1000 combinations
Any help would be appreciated!
EDIT
The point of this question is: 1. Understand if the solution provided in the linked answer applies to my case 2. Know if there a re other ways of solving this that aren't scripting (formulas, excel tools, etc)