Break customer orders based on quantity

Hi,

I have a spreadsheet with a list of customer items they wish to purchase and the quantity of each item and their respective due dates. I am looking to see if a macro can look at the quantity and split each item out into individual line items with a quantity of 1.