Fill down/Duplicating Cells Based on Value Criteria

[KC371]

Looking for some help on a pretty basic process. Purpose is to create labels based on inventory packing list criteria. So lets say I have this sheet:

I need to be able to quickly create the amount lines for each item based on the value. So that the list above becomes this list below and then I'll able to do a mail merge for labels.

Thanks in advance for the help!

[#2]

@KC371 

Please check here https://stackoverflow.com/questions/11841213/copy-value-n-times-in-excel