Repeat Rows "n" amount of Times

[testtesttefsadf1]

I need text and description repeated x amount of times based on on hand values. For example:

Part number = 44-05 Description: Gloves Small Inventory: 4


Part number = 44-06 Description: Gloves Large Inventory: 7


So I would need Part Number and Description for the first item repeated 4 times and for the second item repeated 7 times. It's been driving me crazy that I can't work out my own formula.

[Pete_UK]

It would help if you attached a sample Excel workbook, so we can see how your data is laid out.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon (Attachments button) does not work on this forum.

Hope this helps.

Pete

[testtesttefsadf1]

Hello,

Click Barcodes sheet. I am trying to get Part Number, Barcode, and Description to repeat the amount of times that it shows up on as on hand value for that part number from INV Parts Sheet.

For example,

A2 value from Barcodes, I want the part number, barcode, and description repeated 19 times as it says in w2 from INV Parts list.


Thank you in advance for your help.

[JohnTopley]

in A2 (formula found via Google Search!)

=IF(SUM('INV PARTS'!$W$1:$W$200)>=ROWS(A$2:A2),INDEX('INV PARTS'!$A$2:$A$200,MATCH(ROWS(A$2:A2)-1,SUBTOTAL(9,OFFSET('INV PARTS'!$W$1:$W$200,,,ROW($W$1:$W$200))))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy down

in B2

=IF(A2="","","*"&A2&"*")

in C2 Description

=IF(SUM('INV PARTS'!$W$1:$W$200)>=ROWS(C$2:C2),INDEX('INV PARTS'!$D$2:$D$200,MATCH(ROWS(C$2:C2)-1,SUBTOTAL(9,OFFSET('INV PARTS'!$W$1:$W$200,,,ROW($W$1:$W$200))))),"")

..confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.


See "Sheet1"

[testtesttefsadf1]

Thank you so much!

Do you know any places where I can learn more about the methods behind it?