Dynamic Array formula - Duplicate cell X Number of times

[DarkNight]

I'm trying to write a dynamic array formula that will take a list in column A and duplicate the list a specific number of times as dictated in column B
Input

Apple	4
Orange	1
Pear	2
Banana	3

Desired Output

Apple

Apple

Apple

Apple

Orange

Pear

Pear

Banana

Banana

Banana

Appreciate the help!

 

[Peter_SSs]

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

See if this is any use. Assumes that you are not using a Mac (implementing my point above would also clarify that).

22 04 03.xlsm
	A	B	C	D
1	Input
2	Apple	4		Apple
3	Orange	1		Apple
4	Pear	2		Apple
5	Banana	3		Apple
6				Orange
7				Pear
8				Pear
9				Banana
10				Banana
11				Banana
12
List

Cell Formulas
Range	Formula
D2:D11	D2	=FILTERXML(REPLACE(CONCAT(REPT("</c><c>"&A2:A5,B2:B5)),2,2,"p")&"</c></p>","//c")
Dynamic array formulas.

 

[DarkNight]

Updated my profile. This worked! Thank you so much!
ps I updated my profile

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

.. and for updating your details.