There is a list of number under column A, and there is another list of number
under column B, which is refered to the value in column A, such as
3 [A1] =A1 [B1]
6 [A2] =A2 [B2]
4 [A3] =A3 [B3]
....
8 [A9] =A9 [B9]
I would like to transpose column B startig from cell C1 without changing the
link,
=A1 [C1]
=A2 [D1]
=A3 [E1]
....
=A9 [K1]
Does anyone have any suggestions on how to do it?
Thank in advance for any suggestions
Eric

Enter this formula in C1 and copy across to K1:

=INDEX($A1:$A9,COLUMNS($A:A))

Biff

"Eric" wrote in message
...
There is a list of number under column A, and there is another list of
number
under column B, which is refered to the value in column A, such as
3 [A1] =A1 [B1]
6 [A2] =A2 [B2]
4 [A3] =A3 [B3]
...
8 [A9] =A9 [B9]
I would like to transpose column B startig from cell C1 without changing
the
link,
=A1 [C1]
=A2 [D1]
=A3 [E1]
...
=A9 [K1]
Does anyone have any suggestions on how to do it?
Thank in advance for any suggestions
Eric

Why not use the TRANSPOSE function? Help will tell you how. Remember that
it's an array formula, so you apply it with Control-Shift-Enter.
--
David Biddulph

"Eric" wrote in message
...
There is a list of number under column A, and there is another list of
number
under column B, which is refered to the value in column A, such as
3 [A1] =A1 [B1]
6 [A2] =A2 [B2]
4 [A3] =A3 [B3]
...
8 [A9] =A9 [B9]
I would like to transpose column B startig from cell C1 without changing
the
link,
=A1 [C1]
=A2 [D1]
=A3 [E1]
...
=A9 [K1]
Does anyone have any suggestions on how to do it?
Thank in advance for any suggestions
Eric