Transpose data and retain links to original data

[Neil]

Hi
I know this topic has already been raised but I am not sure I understood any
of the answers. I am a novice where functions like OFFSET and INDEX are
concerned.

What I would like to do is transpose horizontal data from Sheet1! row
$C$4:$CB$4 and place it in Sheet2! column $G$10:$G$61 while retaining the
links to the original data in Sheet1!- how do I do that? What is the formula
which will produce this result.

Regards
Neil

 

[Jacob Skaria]

Try the below formula in G10 and copy down to G61.
=INDEX($C$4:$CB$4,ROW(A1))

If this post helps click Yes

 

[David Biddulph]

=OFFSET(Sheet1!C$4,0,ROWS(G$10:G10)-1) and copy down,
but of course you need to go to G87 (not G61), if you want to go as far as
CB4.