Cell Referencing rows to columns

[Guest]

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

 

[Guest]

copy cells A7:A9, go to other sheet select cell A7, right click > Paste
Special and check Transpose option (at bottom) press Ok.

 

[Guest]

Thanks for your reply Starguy, but copying wont work as I'm summing some of
the fields, also, the first sheet is a pivot table which will have more data
added as the weeks go by which I want shown in the second sheet also.

 

[David Biddulph]

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.