Data Sort with CTRL+F & extracting required cells

[MaheshK5277]

Dear All,

I have an excel file which has 10 columns, out of which i need to work on 3rd column which has list of equipments ( around 5000 equipments of a plant). This column is written with sub-headings as Raw material Processing Area, Utilities Area, Packaging area & each sub heading has different types of equipments ( like pumps, fans, mixers, agitators & son on..).

Requirement:
1 need to extract & make a separate list of equipments which are classified as per their type (like a mentioned above -pumps, fans agitators). I am doing CRTL+F to find a word match for PUMP. The window pops up showing me some 388 cells found. Is there a way to extract these cells which have PUMP in their listing & copy to another column with the entire row data? Any formula please?

Any quick help is sincerely appreciated.

I am attaching a example spreadsheet for ready reference