Hi,

I have a spreadsheet with Part #s in column A. There are quantities in column B associated with the part #s in column A.

Example:

Column A Column B
SFTR-56 35
SFYU-82 6
WRR-83 18

I’d like to pull the Part # onto a new tab of the spreadsheet and list it as many times as the quantity indicates. After that the second Part # listed as many times as that indicates and so on. All in a big long column.
The goal is to use this second “deconstructed” list to use for printing labels.

Hopefully that makes sense.

Any help is greatly appreciated.

Thanks!
Keith