how do i duplicate rows based on a cells value

im trying to get data from one table and add it multiple times to another table based on the max qty product max qty order   product qty   product 1 6 12   product 1 6   product...