=OFFSET($A$1,INT((ROW()-1)/20),0)
--
David Biddulph

"Igneshwara reddy" wrote in
message ...
No, this is not my result.

If 50 is in cell A1, it should repeat 20 time in B column from B1:B20 and
accordingly for A2,A3,A4..................

My results should come as
A B
50 50
25 50
35 50
45 50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
50
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25


"David Biddulph" wrote:

=REPT(A1,20)
--
David Biddulph

"Igneshwara reddy" wrote in
message ...
Hi,

I have 250 lines in A column and I need to paste them 20 times each
line,
could you please help out with the macros.

For Eg:
If I have in A1, number as 12, these 12 should be repeated 20 times in
the
B
column.

Let me know how this can be done.