Hi Alan

Copy A1:C1
Paste Special=Transpose

--
Regards
Roger Govier
"Alan" wrote in message
...
as calculate lines whith colunns
ex:

a1=10, b1=20, c1=30

now put in lines

ex:

a1=10
a2=20
a3=30

thanks!!