vertical linking of cells

vinay

New member
Joined
Oct 23, 2011
Messages
10
Reaction score
0
Points
0
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??
 
Last edited:
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
 
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.
 
Back
Top