formula help request, pull in clean data

hi all,

i have attached a sample.

sheet 1 has all my data, you can see it's awfully dirty.

sheet 2 is where i need a formula in cell B2. i need to pull in all actual data from sheet 1, leaving all the garbage behind.

sheet 3 is a sample of how the end results should be

So sheet 2 needs to look at sheet1, and only pull in columns/rows (B2 thru F infinity) where either, column B is non-numerical or, column C doesn't have a date (which ever is easier to whomever would like to help

I sincerely appreciate any insight, i'm a bit lost on this one...

One solution:

Formula:

Please Login or Register  to view this content.

Thank you VERY much!

Tks for the feedback and mark it as SOLVED, please.