Hello,

I want to randomize a list of names into two columns. I'm a teacher and I'm assigning lab partners that are different every lab. I'm hoping to automate this since what I'm doing now is cutting and pasting. I've tried adding a number to the front of each student, but get stuck after that.

This is what I'd like to do: (periods are just to make spacing, I'd like them to be in separate cells.)

Names:
Darth Vader
Luke Skywalker
Han Solo
Princess Leia
Chewbacca
Obi Wan Kenobi


Partners:
Lab 1
Darth Vader...........Luke Skywalker
Han Solo...............Princess Leia
Chewbacca............Obi Wan Kenobi


Lab 2
Darth Vader...........Princess Leia
Han Solo...............Chewbacca
Obi Wan Kenobi......Luke Skywalker

and so on.


Is this possible?

Thanks,

Paul