Formulate multi results on seperate column

Hi,

I need of some help guys, cant get my head round this one...

Column A has peoples names (eg Steve Smith, Barry Jackson, Terry Tester)
Column B has the number of appointments that each person is responsible for.. (1,3,2)

I need to produce a single column which will display each persons name multiplied by the amount of appointments.

So Column C would look something like this

Steve Smith
Barry Jackson
Barry Jackson
Barry Jackson
Terry Tester
Terry Tester

and so on..

any ideas would be greatly appreciated.