Transpose data and retain links to original data
 

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

Transpose data and retain links to original data
 

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

If this post helps click Yes
---------------
Jacob Skaria


"Neil" wrote:

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

Transpose data and retain links to original data
 

=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.
--
David Biddulph


"Neil" wrote in message
...
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