Formula Help: Create array that repeats list of items X times as based off another column.

[Magoosball]

See image below. I have a unique list of Items in column A and a designated amount of times I want to repeat each item in column B.
I'm looking to create a new array (listed as final answer in the screenshot below) that duplicates the original list in column A the designated amount of times in Column B.
Appreciate the help!

 

[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’)

 

[Magoosball]

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’)

365. I just updated my profile. Should have stated, sorry about that!

 

[Fluff]

Thanks for that.
How about

=TOCOL(IF(SEQUENCE(,MAX(B2:B10))<=B2:B10,A2:A10,1/0),2)

 

[Magoosball]

thank you, worked perfectly!

Thanks for that.
How about

=TOCOL(IF(SEQUENCE(,MAX(B2:B10))<=B2:B10,A2:A10,1/0),2)

 

[Fluff]

You're welcome & thanks for the feedback.