Assuming the data is on rows A1 thru a10 and you want it transposed it from
C1
On cell C1 type
=OFFSET($A$1,COLUMN()-3,0)
and copy it across the columns on row 1


"Mike" wrote in message
...
i have a range of data in one worksheet that is vertical. I need to link
this data to another worksheet in a horizontal format. when click
"transpose" the "paste link" button greys out. is the only way to move
this
data a manual process? hope not, as i have a LOT of it to move.