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.