Creating a Rota

[d488z]

I am trying to create a rota in excel to balance staffing. Trying to create a spreadsheet where each member of staff has a duty rosta with all people in the list. Any Ideas on where I would start?

Thanks in advance.
[TABLE="width: 714"]
<tbody>[TR]
[TD="align: left"]Zone 1 - (1 Staff)
[/TD]
[TD="align: left"]Zone 2 - (2 Staff)
[/TD]
[TD="align: left"]Zone 3 - (2 Staff)
[/TD]
[TD="align: left"]Zone 4 - (2 Staff)
[/TD]
[TD="align: left"]Zone 5 - (2 Staff)
[/TD]
[/TR]
[TR]
[TD="align: left"]Thelma
[/TD]
[TD="align: left"]Bev and Jane
[/TD]
[TD="align: left"]Cheryl and Heather
[/TD]
[TD="align: left"]Carol and Emma
[/TD]
[TD="align: left"]Pat and Kay
[/TD]
[/TR]
[TR]
[TD="align: left"]Pat
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Kay
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Carol
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Emma
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Cheryl
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Heather
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Bev
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Jane
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Roderick_E]

pivot table?