Column is on Sheet1, starting from A1.

On Sheet2, enter this formula wherever you wish to start your duplicated
row:

=INDEX(Sheet1!$A:$A,COLUMNS($A:A))

And copy across as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Gaz1" wrote in message
...
How do I copy a column into a row and keep the links to other workbooks so
that they update automatically? When I transpose when pasting I lose the
option to paste the link.