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