REPT output in rows

[sharshra]

I have a simple requirement of repeating a text in multiple rows. Something similar to REPT function but need the output in rows. I was looking for simple solution but it appears to be not as simple as getting the result in a column using REPT function. Please suggest a simple solution.

For example, REPT("trial",3) returns trialtrialtrial. I need the output in 3 rows as follows.
trial
trial
trial

 

[Eric W]

Try:

Book1
	A
1	trial
2	trial
3	trial
4
Sheet8

Cell Formulas
Range	Formula
A1:A3	A1	=INDEX("trial",SEQUENCE(3,,,0))
Dynamic array formulas.

 

[djclements]

Another option:

=IF(SEQUENCE(3),"trial")

 

[sharshra]

Great!!! Thanks, @Eric W, @djclements. One step further, how can I repeat the text in 2 or more columns?

For example, I have to repeat trial1, trial2 in 3 rows.
Original text -

excel problems.xlsx
	T	U
7	trial1	trial2
Sheet7

Repeat 3 times -

excel problems.xlsx
	V	W
7	trial1	trial2
8	trial1	trial2
9	trial1	trial2
Sheet7

 

[hagia_sofia]

Hello, just:

=IF(SEQUENCE(3),T7:U7)

 

[sharshra]

Fantastic!!! Thanks, @hagia_sofia

 

[hagia_sofia]

Glad to help but I am just standing on the shoulders of giants: @Eric W and @djclements.