help with formula to repeat sequence of text

[locksmith55]

MREXECL REPEAT SEQUENCE OF TEXT.xlsx
	A	B	C	D	E	F
1	Cities		Times to repeat sequence	3		HOW I WANT IT TO LOOK
2	Tokyo					Tokyo
3	Kyoto					Kyoto
4	Osaka					Osaka
5	Sapporo					Sapporo
6	Nagoya					Nagoya
7	Kobe					Kobe
8	Fukuoka					Fukuoka
9						Tokyo
10						Kyoto
11						Osaka
12						Sapporo
13						Nagoya
14						Kobe
15						Fukuoka
16						Tokyo
17						Kyoto
18						Osaka
19						Sapporo
20						Nagoya
21						Kobe
22						Fukuoka
Sheet1

 

[JGordon11]

Book1
	A	B	C	D	E	F	G	H	I
1	Cities		Times to repeat sequence	3		HOW I WANT IT TO LOOK
2	Tokyo					Tokyo		Tokyo
3	Kyoto					Kyoto		Kyoto
4	Osaka					Osaka		Osaka
5	Sapporo					Sapporo		Sapporo
6	Nagoya					Nagoya		Nagoya
7	Kobe					Kobe		Kobe
8	Fukuoka					Fukuoka		Fukuoka
9						Tokyo		Tokyo
10						Kyoto		Kyoto
11						Osaka		Osaka
12						Sapporo		Sapporo
13						Nagoya		Nagoya
14						Kobe		Kobe
15						Fukuoka		Fukuoka
16						Tokyo		Tokyo
17						Kyoto		Kyoto
18						Osaka		Osaka
19						Sapporo		Sapporo
20						Nagoya		Nagoya
21						Kobe		Kobe
22						Fukuoka		Fukuoka
23
Sheet3

Cell Formulas
Range	Formula
H2:H22	H2	=LET(rws, ROWS(A2:A8), INDEX(A2:A8, MOD(SEQUENCE(rws*D1)-1, rws)+1))
Dynamic array formulas.