Repeat and automatically copy row to new row

pls look into attached excel file for better understanding.

What i want:

I want to repeat all the data in row based on value in QTY column,

for example : if row 3 has "2" in column named "qty", then want to repeat it by two times...copy same data of row 3 to new row.

row 5 has 15 value, so repeat it 15 times, add new 14 rows with same data of row5