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

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

"GLS" wrote:

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

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.
--
GLS


"Starguy" wrote:

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

"GLS" wrote:

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

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