Serach for string in cell , then move whole row to a new cell

Try:

=IFERROR(INDEX($A$1:$A$100,SMALL(IF(ISNUMBER(SEARCH("ab",$A$1:$A$100)),ROW($A$1:$A$100)-ROW($A$1)+1),ROWS($B$1:$B1))),"")

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down.

assuming data is in A1:A100

Wow, what a big formula, I was working on something like this:

Please Login or Register  to view this content.

afterwards you paste down, copy column B, paste as values, and sort the values anyway you like.

It works, thank you both so much, you just save my day

Btw how do I remove those rows that has been move to column B from colum A

Happy Friday!