Excel Function

[Guest]

In a worksheet for e.g. Row No. A1 to A6, I have Entered some data
in-between specified range (i.e. A1 to A6) A2, A4, A6, I want to pick up the
data entered in that specified range in B1 to B6 in a SEQUENCE

Example :

ROW NO. INPUT ROW NO OUTPUT
A1 B1 15
A2 15 B2 6
A3 B3 35
A4 6 B4
A5 B5
A6 35 B6


Please guide me which function will solve the problem and I would like to
inform you that it should skip the blank cell, The output should pickup the
only filled data in sequence order as inputed in row A1 to A6.

 

[Guest]

Hi,
In B1,put formula as
=if(a1<>"",a1,if(a2<>"",a2,if(a3<>"",a3,if(a4<>"",a4,if(a5<>"",a5,if(a6<>"",a6,"")))))).
Repeat this in B2,starting from a2; in B3,starting from a3; and so on ...
If the number of rows is more than 7,this formula may not give the desired
result.
K.S.Warrier