I think the main issue is that your data has holes in it. What I would do is fill column A and B with the values from the above cells instead of blanks. At that point adding a filter will show you the data in all the visible rows.
If it is critical that you have bank cells to show separation from the dates then, after filling the cells as I described above, I'd build a PivotTable off the data. That will allow you to filter on the column, but will not repeat data that is showing above.
Bookmarks