I have an inventory worksheet that has details about different products, such as product code, description, price, quantity.
I need to copy these cells into a new spreadsheet such that each row is copied x number of times - based on the number in the quantity column.
I need this in order to import this new sheet into a word mail merge for the purpose of printing some barcodes.

i.e.

Product Description Price Quantity
0001 Table $50 2
0002 Vase $20 2
0003 Painting $60 1
0004 Tray $30 3

I need to copy this data into a new spreadsheet such that:

Product Description Price Quantity
0001 Table $50 2
0001 Table $50 2
0002 Vase $20 4
0002 Vase $20 4
0002 Vase $20 4
0002 Vase $20 4
0002 Vase $20 4
0003 Painting $60 1
0004 Tray $30 3
0004 Tray $30 3
0004 Tray $30 3


Please assist me with with an appropriate macro that will enable me to achieve this.
Thank you.