Format Data with Header Information Between Rows

Hello, 

I have data that is downloaded from a cloud-based application. It looks like this:

I'm interested in creating individual rows with the data from the header rows. So, after applying steps the data would look like this:

After getting the file to this point, I would like to search the File column for specific wording and save only those rows.

Thank you,

Carol