Using Randbetween to generate specific amounts of numbers

Hi,

Im hoping that there is a formula or Excel has an easy way to complete a very tedious task i have to complete.

I have a very long list of names and a number next to them which indicates how many tickets they have.

e.g.
Bob Smith 9
Tom Smith 6

Now, i need to use the =RANDBETWEEN() formula to assign e.g. 9 tickets to Bob Smith, with each ticket number in an individual cell. The second issue i have is that i need my long list of names to have unique ticket numbers (not repeated)

Hope someone can help?