How to do this

Highlighted
Occasional Contributor

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 Replies
Highlighted
Copy paste the first four rows five times (under each other), then sort?
Highlighted

@adeliasuharly 

For such sample

image.png

in D4

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

and drag it down