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.

Zone 1 - (1 Staff)	Zone 2 - (2 Staff)	Zone 3 - (2 Staff)	Zone 4 - (2 Staff)	Zone 5 - (2 Staff)
Thelma	Bev and Jane	Cheryl and Heather	Carol and Emma	Pat and Kay
Pat
Kay
Carol
Emma
Cheryl
Heather
Bev
Jane

<tbody>
</tbody>

 

[Roderick_E]

pivot table?