Select your column array on sheet 2, then with the active cell A7, insert
=TRANSPOSE(), click in the parentheses, go to sheet 1 and select your row
array, then commit the array formula with Control-Shift-Enter, so you'll see
something like {=TRANSPOSE(Sheet1!A7:J7)}

Alternatively, in A7 on sheet 2, insert the formula
=OFFSET(Sheet1!A$7,0,ROW()-7), and copy down as required.
--
David Biddulph

"GLS" wrote in message
...
I have one spreadsheet where the data is shown weekly by row, I want to
summarise this into a spreadsheet where the data is shown weekly by
column.
In otherwords I want to reference cells A7, A8, A9 etc on the first sheet
to
A7,B7,C7 etc on the second sheet. The first sheet is linked to other
files
so I dont want to change it.

Can anyone help please?

Many thanks
--
GLS