Another play using non-array formulas ..

Source data assumed in cols A to F, key col = col A

In H1:
=IF(A1=1,ROW(),"")

In I1:
=IF(ROW()COUNT($H:$H),"",INDEX(A:A,SMALL($H:$H,RO W())))
Copy I1 to N1. Select H1:N1, copy down to cover the max expected extent of
source data, say down to row 500? Minimize/hide col H. Cols I to N
auto-returns the required result lines, all bunched neatly at the top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---