Excel 2007 : sort rows conditional of cell content

I am trying to sort an inspection report by first failures. I need to sort by unit and then by date/time. Filter out blank operators. If the row has Inspection in column C and the row below it has the same unit number and is not another inspection copy that row to another page.In my example the lines in yellow would be copied the one in red would not be.

Thanks in advance to all that look at this to help.