I have dates starting from today until end of the year as header row, and activities specified in the header column. An activity can be done on a specific day. Not all activities are done daily so I have lots of blank cells to deal with. Even the activities are around 300 in number adding to difficulty while reviewing the week.

To review activities in a week/fortnight/month I have to select individual column filter all non-blanks value. Is there a smart of selecting multiple columns and filtering non-blanks.

I have googled it around and the best bet seems to be copying it to somewhere else...definitely not the solution that can help me. I am keen for just a filter that can help me select non-blanks for a week/fortnight (or selected columns), as any changes to a activity should be reflected in the cell itself.
Any help or guidance will be highly appreciated.

BRgds