If Then and Look Ups - Need Help!

[stew57]

I have data being provided to me in an awkward format and I need to reformat the data to be more user friendly.

I am trying to create a table that will automatically lookup the accurate data in one cell, if a preceding cell contains certain criteria. For Example:

Example 1.)
If Cell C12 contains the words "First Name", then I would like to populate the exact information that is in Cell C14.

Example 2.)
If Cell C15 contains the words "Hours Worked", then I would like to populate the exact information that is in Cell C17.

I have attached a spreadsheet providing a visual of what I am starting with and what I would like it to look like in the end.

Can anyone help??!!

[kimrh]

I'm sure someone can come up with something better, but here is one exemple:

[FDibbins]

That is a very good solution kimrh

[stew57]

Wow! This is perfect, kimrh! You did a great job!

Thank you so much. This will help more than you know!

Have a good one.

[kimrh]

Thanks FDibbins
Stew57: If you want to make it even better you should remove my filter from "Text", and insert the "Hours" to the reporting filter. Remove (blanks) and "" from the reporting filter, and it will always be dynamic if you have different dates next time.