Repeat different values based on adjacent column numbered inputs

[Drew_]

I'm trying to have values repeat a specified number of times, but the number can be different and is determined based on a drop down. I've attached a screenshot here:

I would like a formula in G1 that says "For all values that equal "Yes" in Column C, repeat the corresponding values in Column B the specified times in Column D. If anything equals "No" or is blank in Column C, ignore it" and have it be an array output in Column G. I can get =REPT(B2,SEQUENCE(D2,1,1,0)) to work for just the first input but it's not scalable nor dynamic.

Any help anyone can provide is much appreciated!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=TOCOL(IF((C2:C100="yes")*(SEQUENCE(,MAX(D2:D100))<=D2:D100),B2:B100,1/0),2)

 

[Drew_]

Thank you for the tip about the Account Details, I've gone ahead and updated that and saved it.

You are a GENIUS, this works perfectly!! Thank you very much.

 

[Fluff]

You're welcome & thanks for the feedback.