How to transpose a list of reference cells without changing the li

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top