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.