creat the records based on the values in another sheet
 

I have a question on how to creat the records based on the values in another
sheet. Here is the situation. I have a sheet with the info like this:

Client_ID Order Quantity

100 product1 2
200 product2 1
300 product1 4
.......

What I want is to create the following info in another sheet based on above
quantity value. If the quantity value is 2, I want to create two
records..... In this case, the following info should be created:

Client_ID Order

100 product1
100 product1
200 product2
300 product1
300 product1
300 product1
300 product1
.......

Thanks for your help