how to do a copy from a series cells

[sayhi80]

Hi guys, I have a long list at column A, and I want to do a copy in column B for two or three of each. how do I use a formula to do that? thanks.
A
john
mike
phil
paul
......
B
john
john
mike
mike
phil
phil
paul
paul
......

 

[sayhi80]

can anyone help please?

 

[FormR]

I want to do a copy in column B for two or three of each.

Hi, here is one option you can try:

Excel 2013
	A	B	C
1	List	Result	Repeats
2	john	john	3
3	mike	john
4	phil	john
5	paul	mike
6		mike
7		mike
8		phil
9		phil
10		phil
11		paul
12		paul
13		paul
Sheet1

Cell Formulas
Range	Formula
B2	=T(INDEX($A$2:$A$1000,ROUNDUP(ROWS($B$2:B2)/$C$2,0)))