How to do this

[adeliasuharly]

hello,if anyone know how to make data like this:

A

B

C

D
... 

turn into

A

A
A

A

A

B
B
B
B
B

C

C
C
C
C
...

please tell me,thank youu

[#2]

Copy paste the first four rows five times (under each other), then sort?

[#3]

@adeliasuharly 

For such sample

in D4

=INDEX(B:B,INT((ROW()-ROW($D$3)-1)/5)+ROW($B$1)+1)

and drag it down