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