Repeating a pattern of Cells

[Theemeadelis]

I have a pattern of 25 cells (in column B) that I need to repeat many times over in the same column.

The pattern is showing below:

So essentially it will look as follows (ignore the colours please - just for ease of seeing the pattern):

Thank you in advance for any help that can be provided.

 

[Fluff]

How many times does it need to repeat?

 

[Theemeadelis]

How many times does it need to repeat?

Including the first occurrence of the pattern - 127 times.

 

[Fluff]

Ok, how about in B27

=TOCOL(IF(SEQUENCE(,126),B2:B26),,3)

 

[Theemeadelis]

Ok, how about in B27

=TOCOL(IF(SEQUENCE(,126),B2:B26),,3)

Perfect - thank you again

 

[Fluff]

You're welcome & thanks for the feedback.