All possible combinations in 7 rows

[mtordin]

I have 7 rows, each row has the options "Low", "Medium", and "High". I need to combine all 7 rows so for example one possible combination would be "LLLLLLL", then "LLLLLLM", then "LLLLLLH", then "LLLLLML" and so on and so forth. The order does matter because each row represents something different. How could I create a formula to make this work? I have found a formula which combines everything in two rows but I am not an excel expert and I dont know how to expand it to 7 rows. The formula is:

=IF(ROW()-ROW($D$1)+1>COUNTA($A$1:$A$4)*COUNTA($B$1:$B$3),"",INDEX($A$1:$A$4,INT((ROW()-ROW($D$1))/COUNTA($B$1:$B$3)+1))&INDEX($B$1:$B$3,MOD(ROW()-ROW($D$1),COUNTA($B$1:$B$3))+1))

I dont know if this will help but I hope it does. Any help is appreciated thank you!

 

[mass junior high]

Please sir , I wish to create the same thing but I want 12 rows with two options, lose(L) and win(L) , examples
Wwwwwwwwwwww,wwwwwwwwwwwL, Lwwwwwwwwwww. How can I do this with the formula given in the previous post for 7 rows ;3 options


=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(RIGHT("000000"&MMULT(MOD(INT((ROW()-1)/{1,3,9,27,81,243,729}),3),{1;10;100;1000;10000;100000;1000000}),7),"0","L"),"1","M"),"2","H"
Thanks