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 16807 combinations
A B C D E
54 23 43 1 1
21 45 433 5 51
25 65 456 3 3
65 66 5678 100 5
12 77 980 5 6
13 90 878 6 66
111 909 662 50 55
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 1 5
54 23 43 1 6
54 23 43 1 66
54 23 43 1 55
54 23 43 5 1
54 23 43 5 51
54 23 43 5 3
54 23 43 5 5
54 23 43 5 6
54 23 43 5 66
54 23 43 5 55
…
…
111 909 662 50 55
Manually it will take forever and frankly speaking, I'm not an expert in Excel. Please help me.