I've got a list of 8-10 candidates that are doing a series of back to back interviews with 7 interviewers. Is there a way using MS Excel to create a master schedule that will auto populate such a table?

9:00 am 9:20 am ........ 5:00 pm
Doctor A: Candidate #1 Candidate #2....... Candidate #8
Doctor B: Candidate #4 Candidate #3....... Candidate #6

Doctor C: Will interview only 5 candidates
Doctor D: ditto

Doctor E: Will interview only 4 candidates
Doctor F: ditto
Doctor G: ditto