Hello,

I have a data set with 3 columns that has pairs of roommates with their current room number. I want to generate a new data set such that each person gets a new room mate and both of them get a new room (with no repetition of any kind). Any suggestions on how I can do this?
Thanks in advance for the help.

Best,
Janaki