I have 16 numbers in the A group (1A - 16A) and 16 numbers in the B group (1B
- 16B).
Condition 1: Each number in A has to be combined with 6 unique numbers in
the B group in a random order.
Condition 2: Two numbers in A cannot meet with a B member at the same time
(e.g., 3A and 4A cannot be combined with 1B in round 1).

Is there a way for excel to randomly generate these combinations? Thanks in
advance.