Copy formulas in Column

[Meeru]

Hi,

I have to copy numbers from cell a1, b1,c1...........z1 to a20,a21,a22,a23...
so. for e.g--

a1 = 21
b1 = 23
c1 = 24
etc
z1 = 40

i need to copy as follows:-
a20 = a1
a21 = b1
a22 = c1

Is there an easy way to copy the numbers instead of typing one by one ....
I have many records to copy.....

Thanks for your kind help
Meeru

 

[Jacob Skaria]

--Select the range A1:Z1 and copy
--Select cell A20. Right click>PasteSpecial>check 'Transpose' and click OK