link from horizontal cells to vertical cells

  • Thread starter Thread starter cuongvt
  • Start date Start date
C

cuongvt

I'm newbie to excel and I have one problem:
for example:
I want to link data of cells from a13,b13,c13, d13 etc (horizonta
cells) to L1,L2,L3,L4 etc(Vertical cells). (a13 to L1, b13 to L2, C1
to L3 etc)

I did as follows:
on cell L1, I inputed "=a13" and then I put the cursor to bottom righ
corner of the cell, the cursor changes to a plus sign (+), I dra
vertically and release the mouse.

The problem is: L1 is linked to A13 but L2 is linked to A14, L3 i
linked to A15 etc (I want it must link to a13,b13,c13,d13 etc)

Could you teach me to solve this problem. I need you help.
Many thanhs. :
 
Hi
in L1 enter the following formula:
=OFFSET($A$13,0,ROW(1:1)-1)
and copy this down
 
Select cells A13:D13 and enter the following formula:

=TRANSPOSE($L$1:$L$4)

Press ctrl-shift-enter.

HTH,
Ryan
 
Back
Top