Formula for duplicating cells

[majesticgiftware]

Hi

I have 2 columns with info. The first column is a quantity and the second is an item number. I am looking for a formula that will create new cells with item numbers in the quantities that are in the first column.

Any help will be greatky appreciated.

 

[Peter_SSs]

Worked perfectly. Thnx.

Glad it was successful for you. Thanks for the feedback.