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