Random Output

Hi,

Is it possible in Excel to create a formula that will produce a combination or random output? For example, I have 2 columns with the following data:

Column 1 Column 2
5 A
7 B

The following formula, "=COUNTA(A1:A11)*COUNTA(B1:B11)" works well to provide the total number of possible combinations. In this example, there's 4 possible combinations to combine data from Column 1 with data from Column 2


Now, I'm looking for a formula that will actually produce a total possible output, such as following results:

5A
5B
7A
7B

Please assist.


Thanks

=COUNTA(A1:A11)*COUNTA(B1:B11)
should do the trick