How to get a range to repeat multiple times using a formula in excel

=TOCOL(C5:C7&EXPAND("",1,B2,""),,1)
=TOCOL(IF(SEQUENCE(1,B2,,0),C5:C7),,1)

Microsoft Office 365, Beta Channel, Version 2309

[mattknight]

Excellent tutorial, thank you. Gave me a rock solid foundation to build something more complex (involving nested TOCOL functions, dealing with arrays of different lengths) and the result is a complete and fully aligned series of four dynamic arrays constructed really clearly. Months from now, I reckon I won't have too much trouble auditing these formulae to figure out what I was trying to do and how I did it, thanks to this.

[gandhisunil]

Amazing and very useful trick, Thanks

[Shivam-]

Thank you very much for sharing, it's been very helpful. 🙂🙂

[wilderramirez]

Great trick Karina! Thank you for sharing

[AdolfoLeonSepulveda]

Hi Karina
I've seen several videos showing how to repeat ranges in a column.
Of all these videos, yours is the most ingenious.
How do you do it?
It's amazing!

[yazazan]

Small comment for everyone's benefit. If you're working with DATES, use the second method, that is the one with sequence.

[tailethanh]

thanks, really helpful and directly to the solutions

[neerajgupta]

How to count a Specific repeated word array in excel Example
= 2 means P is repeated 2 times with an array of 6.
I need formula for the same.

[SangeethaV-cj]

how to do this for a range of 2 columns