G
Guest
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
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