hide blank rows

Hi,

I have this document all set up where data is put into the numbered tabs and it feeds into the continuum page. Users can then alter the values in N & Q to hide the relevant sections. There is a macro that hides all the blank rows.

I have started to add a section at the bottom based on some different values however I can't work out how to alter the macro to also hide the blank rows in this section.

If the values are equal to any of these B3.3, B3.2, B3.1, B2.3, B2.2, B2.1, B1.3, B1.2, B1.1, A2.3, A2.2, A2.1, A1.3, A1.2, A1.1 then it will put the name and code in the one cell but I need the blank rows hidden. I don't necessarily need these sectioned off like the sections above. It would be better if they end up looking like below. So maybe I need to change my formula and then add another macro to hide the blank rows in this section?

Jenny Black B3.3
Simon Green B1.2
Mary Yellow A2.2

Hopefully someone can make sense of that!!

Any help would be greatly appreciated.