Extract data in a column

[luis_marques]

Hi, i need to extract data like is orientated in the attached file.
B.R.

 

[Luke M]

Hi luis_marques,

See attached, which is your file with solution. I added a helper column to flag rows of interest, and then use array formula to extract those rows.
For more on how the array formula works:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

 

[luis_marques]

Many thanks Luke.