rotation schedule
 

I want to make a medical rotation schedule
for example:

"Dr. Tom is working in the ER during March"

I want to generate two tables... one sorted by the doctor and the second
sorted by the rotation

Table #!: Tom's Line willhave all his rotations on the same row, columns
would be months

Table #2: ER's line would have all the covering Doctors names, columns would
be months.

I want to create one table and have the second one generated automatically,
and changes made in one, take effect in the other... I have three variables.
Doctor Name, and Month.

Help
Thanks in advance