Copy text into several rows

[ninucar]

Hello.

I want to copy/paste text into 100 rows at once. For example, I have 3 different keywords, K1, K2, K3. I want to paste K1 into 100 rows, then K2 in second 100 rows.

What is the simplest way to do it?

Thank you in advance

[caf20012]

Hi,

Can't you just put K1 in "A1" cell, K1 in "A2" cell the highlight both and drag down until you're in row 100?

Then repeat this process?

[ninucar]

I know that method, but I have too many keywords and it's hard to fulfill this task using this method

[Ghozi Alkatiri]

ie your data at A1:A3

the first formula to repeat 100 each data

=INDEX($A$1:$A$3,(TRUNC(ROW(1:1)-1)/100)+1)

copy down

[ninucar]

Thank you very much! It works great