Random combination from 2 colums

Hi, is there any possible way (preferably with macros) that I could generate a combination between 2 columns of values?
E.g.

Column A: Apple, Orange, Pear, Jackfruit
Column B: Monkey, Tiger, Lion, Leopard, Chimpanzee, Gorilla

Generated column: Apple-Tiger, Orange-Lion, Pear-Monkey, Jackfruit-Gorilla, Orange-Leopard, Pear-Chimpanzee
*Requirements:
1. The number of combinations generated should be the same as the number of rows in the column (A or B - whichever has more) that has values. i.e. Column B has 6, Column A has 4: Combinations generated 6
2. Each value in A or B should appear at least once.

Appreciate any help. Thanks!

Hi thanks for the help. But is there any way i can change it such that it does not generate all possible combinations? I do not actually require ALL possible combinations.
e.g. if Column A has 4 values and column B has 6 values, then I will only need 6 combinations
e.g. if Column A has 8 Values and column B has 6 values, then I will need 8 combinations.

Thanks.

Sorry, my bad for I wasn't clear. Please allow me to explain with 2 examples. The purpose of the combinations is to allow me to test the card types with different currencies.
Example 1:
Column A (4 values) Column B ( 5 values)
Visa USD
MasterCard EUR
AMEX CNY
Alipay THB
AUD

I just need to test each card type and currency at least once, so I don't need ALL possible combinations or permutations. So the results should be something like that:
MasterCard-CNY, AMEX-AUD, Alipay-THB, VISA-USD, VISA-EUR. -> so 5 combinations will do since I get to test each of them at least once.

Example 2:
Column A (6 values) Column B ( 4 values)
Visa USD
MasterCard EUR
AMEX CNY
Alipay THB
Unionpay
JCB

So the results should be something like that:
MasterCard-CNY, AMEX-THB, Alipay-THB, VISA-USD, Unionpay-EUR, JCB-EUR -> so 6 combinations will do since I get to test each of them at least once.

Essentially, the number of combinations will depend on the Max no. of values within Column A and B - whichever has more.

Hope that was clear! Thank you in advance for your help!

i understand that, but is it possible that the number of combinations be only the larger number of both columns?
Column A - 4 items; Column B - 6 times => Combinations = 6
OR
Column A - 8 items; Column B - 3 items => Combinations = 8

My earlier example:
Column A______Column B
__Visa________ USD
MasterCard ____EUR
_AMEX________CNY
_Alipay________THB
______________AUD

SAmple Results: MasterCard-CNY, AMEX-AUD, Alipay-THB, VISA-USD, VISA-EUR. -> so 5 combinations will do

Originally Posted by shg

How do you know (how do I know) which 5 combinations?

It should be a random matching. So each currency should be in ay of the 5 combinations once only and each card types should be in any of the 5 combinations at least once

Hope that clears it up. Thanks!