Filter multiple columns

[ConfuddledOne]

I have a spreadsheet where columns K-Q are set up to highlight upcoming and outstanding items via conditional formatting.



I want to remove/hide/filter all rows that don't contain an outstanding item in any of those columns. At the moment I'm filtering each column then copy and pasting to a new table, which is quite time consuming.

While having it all in one table would be good, a way to create a table for each column would be an alternative if easier.

[xor]

Take a look here.

[Pecoflyer]

@confuddled
Hi
please note that current courtesy is not considered offensive on public free forums.
A " Hello" or "thank you" is always appreciated.
Cheers