banburkr's blog

Conditional Copy in Excel

I have a list of part numbers, and the associated onhand quantities for these numbers in the adjacent cell. I need to create as many copies of each part number as there are onhand quantities in a list, including all of the part numbers. So if there are 3 of part 123, I need the column to have 123, 123, and 123 in each corresponding row below the heading (A2, A3, and A4). If the next part number in the original list is 456 and there are 5 on hand, I need the rows A5, A6, A7, A8 and A9 to have 456 in them, and so on. Is this possible?

Syndicate content