Repeat Item a Number of Times based on Cell Value

Hello all!

I have a quick problem that hopefully someone can help me with

Basically I have column C which has Item numbers for different products. This list, in my original workbook, is generated using dynamic arrays, so it is dynamic and automatic.

I also have column D which has the number of times I want the item number to be repeated (this list is also generated using dynamic arrays in my original workbook).

What I need is shown in column G.
As you can see the items are in one column repeated the number of times that is specified in column B.

How could I accomplish this?
If at all possible, maybe try to make the solution use dynamic arrays so everything is automatic and dynamic?
If not possible, any other type of formula will be well received and deeply thanked!

I thank you in advance for the help!

Best regards!

segrxgW.png

Edit: I used Bebo021999's tip and got around the sucuri firewall to post formula properly.

Try in G6 and copied down:

Formula:

Please Login or Register  to view this content.

For some reason I get a firewall warning when I type formula with that sign above.
Please check file attached.

Good luck!

Well noted, p45cal. Thank you for that.
I haven't seen your solution, but if your observation turns out as fact, I would make a little change to my formula in post #2.
Replace the G5+1 argument with this:
INDEX($C$6:$C$28,MATCH(G5,$C$6:$C$28,0)+1

Cheers!

@Estevaoba,
to avoid sucuri firewall, try to add space before and after the greater/smaller sign, like this: " > "

@djhantulip,
Try in J6=C6
J7:

Please Login or Register  to view this content.

Drag down

Thanks for the tip, @Bebo021999. It works like a charm!

Take care!

Or:

=IFERROR(INDEX($C$6:$C$28,MATCH(0,INDEX(--(COUNTIF($F$5:F5,$C$6:$C$28)=$D$6:$D$28),0),0)),"")

see sheet.