Hi Melvin,

Thanks so much for your quick reply! That works fine. However, I happen to have lists of variable lengths. In other words, if 2 people are missing in the Bachelor's category I will have 2 empty rows in that column. That's why I had my categories separated in columns. So if there is a way to create those teams without changing the way the data lay out that would be great. Otherwise I am now looking for a way to automatically merge my 3 columns into one, given that each column's length is variable.