Filter multiple locations in a single spreadsheet

[C_Rieker]

Hi all.
I have a spreadsheet that has multiple sections that need to be filtered. I need to filter out any blank rows in each section. The problem I am having is that Excel will only let me filter one section at any one time. I know I can make them a Table to filter them, but Tables don't allow merged cells (that I am aware of) and my spreadsheet relies on merged cells for layout.

My sections I need to filter are - A20:I48, G54:I60, A63:I70. Everything in-between these sections need to stay visible. Is there a way I can apply multiple filter locations without turning them into tables?

TIA

 

[Fluff]

Is there a way I can apply multiple filter locations without turning them into tables?

Not really, you could possibly use a macro t hide rows, but macros don't like merged cells.

 

[C_Rieker]

Not really, you could possibly use a macro t hide rows, but macros don't like merged cells.

I suppose I could do a loop of each row in each section and hide rows based on a criteria. Its a shame the filter can only be applied once :/

 

[Fluff]

Personally I would get rid of the merged cells as they are an abomination & should be avoided like the plague. Then I would turn the data into tables.