PDA

View Full Version : vertical linking of cells

vinay
2011-10-25, 08:06 PM
Hello Everyone.!
is there any method to make verical linking of cells..?
Not getting my point??
Ok.. Here is an example
A1=m
A2=n
A3=o
A4=p
.....onwards....
if i put value of
B1 to ---> "=A1" ,, indirectly saying "m"
and
of C1 to ---> "=A2",, indirectly saying "n"
Then can i use any method by which it automaticaly takes value of the next cells? i.e. D1 = "=A3" , E1 = "=A4" , and onwards??

jpr73
2011-10-25, 11:16 PM
Hay,
You have 2 possibility :
- Copy the data, select the cell where you want the first data, Paste Special then Transpose
- By formula, select the first cell where you want the first data, select in horizontal the same number of vertical cell, wrote the formula =TRANSPOSE(A1:A4) and valid by Ctrl+Shift+Enter (Array Formula result {=TRANSPOSE(A1:A4)})
You can also put your data in a table and the formula will be =TRANSPOSE(Table name) and also valid as an array formula
Best regards

JoePublic
2011-10-26, 08:15 AM
One easy way is to enter zzA1 in B1 and zzA2 in C1, select both cells then drag across as far as you want. Now replace (Ctrl+H) zz with =
Alternatively, IN b1:
=INDEX(\$A:\$A,column()-1)
and copy across.