You can write formulas to effectively transpose the data.

Converting vertical data to horizontal:

If you want data in cells A2:A11 to be referenced across columns, use a
formula like this in the first column and then copy it to the other cells
where you want the data to appear.

=OFFSET($A$1,COLUMNS($A:A),0)

Converting horizontal to vertical

Assume your data is in cells B1:K1, use the formula

=OFFSET($A$1,0,ROWS($1:1))


"BorisS" wrote:

I have very large sections of data which I need to transpose as links.
Problem is that the copy/paste links function cannot be followed up with the
copy (the linked cells)/transpose option, without having the transposition
screw the links up. Any way around this?
--
Boris