Help with formula that prints repeating text

[locksmith55]

Trying to make a dynamic formula in excel that can print repeating text like shown below where number of rows should be equal to number to the right of the text. I use MS365 Office.

Please try to keep solution not too complex.

Appreciate any help I can get!

Book1
	A	B	C	D
1				How I want it to look
2	Apples	1		Apples
3	Pears	2		Pears
4	Bananas	0		Pears
5	Mangos	3		Mangos
6				Mangos
7				Mangos
Sheet1

Cell Formulas
Range	Formula
D2:D3,D5	D2	=A2
D4,D6	D4	=A3
D7	D7	=A5

 

[Marcelo Branco]

A solution using a helper column F1:F5 (in gray)

Pasta1
	A	B	C	D	E	F
1				How I want it to look		0
2	Apples	1		Apples		1
3	Pears	2		Pears		3
4	Bananas	0		Pears		3
5	Mangos	3		Mangos		6
6				Mangos
7				Mangos
8
Plan1

Cell Formulas
Range	Formula
F1:F5	F1	=SUM(B$1:B1)
D2:D8	D2	=IF(ROWS(D$2:D2)<=F$5,INDEX(A$2:A$5,MATCH(ROWS(D$2:D2)-1,F$1:F$5)),"")

Hope this helps

M.