a simple way is to use a helper column
enter =rand() next to each name
select both data sets and sort by the RAND column
select the teams from the first, second, third and fourth sets of six.
each time you resort, you will get a different combination