reference to question and answer below, how to generate all possible 3 digit combination of the numbers 0-6
i have similar case (need to generate all possible combinations) but for set of values like in table below, total possibilities will be 3024 combinations
A B C D E
54 23 43 1 1
21 45 433 2 51
25 65 456 3 3
65 66 5678 100
77 980 5
90 878 6
909
combinations will look like
A B C D E
54 23 43 1 1
54 23 43 1 51
54 23 43 1 3
54 23 43 2 1
54 23 43 2 51
54 23 43 2 3
...
...
...
65 909 878 6 3
manually it will take forever and frankly speaking, I'm not an expert in excel. please help me.