is there a rept() array formula. I need this result

[jts2004]

A1 = 4 B1 = x
A2 = 2 B2 = y
A3 = 7 B3 = z


I need C1 to look like this xxxxyyzzzzzzz


this is a simple example. my real data as 200 plus rows. I was going to use rept(B1,A1) & rept (B2,A2 etc.... but that's taking too long

 

[FormR]

Hi, if you have a newer version of excel with the CONCAT() function available you can try:

=CONCAT(INDEX(REPT(B1:B3,A1:A3),0))

Otherwise you'll likely need a custom user defined function.

 

[jts2004]

no macros please

 

[Special-K99]

Doubt you can do this via formulas.
VBA would do it.

There's a TEXTJOIN fuormula in Excel 2019 or Office 365 subscription but it looks like a VBA solution would be best.

 

[jts2004]

that worked great thank you!

 

[jts2004]

=CONCAT(INDEX(REPT(B1:B3,A1:A3),0)) worked fine.