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