Need to repeat records

Hello everyone…I have a table that looks like this:

CustNo / BullCode / Doses
123456 / 123HO3214 / 3
321654 / 654JE1245 / 5
456789 / 478AY6549 / 10

and so on.

What I am trying to do is for each record that shows more than one dose as above, I need to repeat that line to match the number of doses

For example the first line I show you here needs to look like this when I’m done:

CustNo / BullCode / Doses
123456 / 123HO3214 / 3
123456 / 123HO3214 / 3
123456 / 123HO3214 / 3

Quite honestly at this point, I no longer care about the number of doses, I just need it to list it 3 times….

I’m certain there must be a way…Any assistance is greatly appreciated.

TL