Copy Data from Sheet 1 to Sheet 2

Registration date
Friday March 17, 2017
Last seen
March 17, 2017
I need to copy data from sheet 1 to sheet 2 based on a Keyword or search criteria.

However, the data is available in hierarchical format. I need a program to copy this data in hierarchical format to a column format.

The row which has the keyword should be copied to sheet 2. It should search for multiple columns as data is in hierarchical format. Also, the empty cells within the row should be removed.

Please help.