Can excel read a number from one field and copy information into the same number of rows

Hi all

It's a bit tricky to explain so I've attached a couple of docs. The attachment called template is a simple example where I've got names of staff at the top and the volume of hours they work. Underneath is the work that needs to be done and split up between the people pro-rota to the number of hours they work. That's the easy bit which I've done, but I'm wondering if there's anything excel can do to read how many pieces of work each person should have and put their name against that specific volume of pieces of work. The attachment called idealtemplate is what it would look like in my mind but I've just manually typed the names in this one, rather than having the functionality to automatically do it.

Any help would be greatly appreciated.

Thanks

I did it with a few formulas, like this

- repeated each name "volume" number of times, comma separated
{=REPT(B1:E1&",",ROUND(B3:E3,0))}
Sarah,Sarah,Sarah,Sarah,Sarah,Sarah, Bob,Bob,Bob,Bob,Bob, Sam,Sam,Sam,Sam,Sam,Sam,

- concatenated all four series of names into one cell
=G3&H3&I3&J3
Sarah,Sarah,Sarah,Sarah,Sarah,Sarah,Bob,Bob,Bob,Bob,Bob,Sam,Sam,Sam,Sam,Sam,Sam,

- found out where the first commas was
=FIND(",",G4)

- to pull the first name in the list
=LEFT(+G4,E6-1)

- then found out the rest of the commas
=FIND(",",$G$4,E6+1)

- and the rest of the names
=MID($G$4,E6+1,E7-E6-1)


here's the ideal template with the formulas
ideal template.xlsx

Wow that is amazing! Thanks so much, seems to work perfectly!