I have a list of 214 names in column A. Column B has a room number that students belong in next to each name. I need to create a list of names for each room number in columns C, D and E. When I put a number in column B next to the name of a student in column A how can I get the lists to populate automatically with student names in columns C, D & E? There must be a way!