Remove or hide two null/empty fields in a row

I exported data from another reporting tool and I'm trying to figure out how to create a formula to remove two empty 'daysinbetween' fields. The good data will have an empty cell then a number consecutively. The bad data will have two fields with a null value and Im trying to either to remove or hide. I have attached a gif and word doc to show examples of the good data I'd like to keep, and the bad data, Im trying to remove. Any suggestions would be helpful.

Thanks!
M

You'll need VBA I think.
Perhaps post a real sheet so we can work with it?

May not be the most elegant of solutions but you could populate E4 and down with the following formula:

Please Login or Register  to view this content.

Then filter based on column E and uncheck Hide.
Let me know if you have any questions.

If I understand this correctly, your saying that instead of a zero D9 is blank. If that is correct then the following formula will gives the same "Hide" and "Show" results:

Please Login or Register  to view this content.

Let me know if you have any questions.

The reason that the formula was not working was that the number of rows between the blue highlighted rows changed from 3 to 4. this modification to the formula, which can be pasted in E5 and double clicked down, will account for that:

Please Login or Register  to view this content.

However, if the pattern of row numbers between the blue highlighted rows is not constant, as seems to be the case in last instance, then we'll need to look at a different formula.
Let me know if you have any questions.

Here is another way to get "Hide" and "Show" in column E that doesn't depend on a Mod of the row number. It does incorporate some helper columns, which could be hidden for aesthetic reasons. If the row is an "Order date & time" row then column F gives the row number, column G gives the next "Order date &time" row number. G3 gives the maximum number of rows to look between "Order date & time" rows, so it can easily be changed if needed. The formulas for columns E, F and G respectively are:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Here is a copy of the file from post #9 with the formulas applied: Copy of June-July sample data.xls
Let me know if you have any questions.