Repeat names in a list by number of times in a cell

[tonywatsonhelp]

Hi Eveyone,
Hope someone can help me with this,
I need a formula that can create a list of names reapeting the name the number of time in a column,
So In Range B5:B105 in have a list of names (wont always be to 105 but this is the max,)
In range D5:D105 I have a number, this number is the number of time I want that name to be repeated,
what I like is a formula in column F to give me the list of names, the number of times in column D
like this:

	A	B	C	D	E	F
1		Name		Times to repeat		result i'd like
2		Name1		2		Name1
3		Name2		4		Name1
4		Name3		1		Name2
5		Name4		2		Name2
6						Name2
7						Name2
8						Name3
9						Name4
						Name4

happy to add helper columns if needed, please help if you can

 

[Fluff]

How about

=TOCOL(IF(SEQUENCE(,MAX(D2:D200))<=D2:D200,B2:B200,1/0),2)

 

[tonywatsonhelp]

Thank you fluff worked perfectly

 

[Fluff]

You're welcome & thanks for the feedback.