excel and permutations

Firstly let me apologize, I am not very experienced in excel and I am about to ask a what feels like a very complicated question. Any help would be appreciated

firstly I have a table that is 3 columns wide and 10 columns deep, like so.

a - b - c
d - e - f
g - h - i
j - k - l
m - n - o
p - q - r
s - t - u
v - w - x
y - z - aa
ab - ac - ad

What I firstly need to do is generate all possible combinations with the parameters that you can only pick one of the three cells from each row and it must use one from each of the 10 lines.
I.e. a, e, h, k, m, q, t, x, z, ab,

The second task is, if each cell was assigned a numerical value i need to know the value of each combination (using my previous example) I.e. a*e*h*k*m*q*t*x*z*ab =
this needs to appear in the column next to the generated combination.

Please not this is for my boss so I am not sure of its application. I am not very experienced in advance excel. If anyone had this type of template already and is will to share it I would be eternally grateful.

Many thanks

Originally Posted by zbor

I don't see why you need to start poll??

Try this attachemnt adopted from this shg solution.

Sellect row 21 and extend formula down for 59049 rows (Cell B1)... Cause that's how much permutations you have.

You sir are a genius, I have managed to complete rest based of your help.

I appreciate what you have done.

Many thanks