Create multiple rows of duplicate data

[Caz23]

I am using Excel to extract information from a database, filter and format it. That file is then used as the data source for a mail merge in Word for printing labels. My issue is that I need to be able to allow an operator the ability to manually enter the quantity of each label (or row of data in Excel). My thought was to allow them a column to enter the "print quantity" and then create that many rows in the data file prior to merging into Word. Any ideas?
Thanks,
Caz