'Excel FILTER to return array non zero columns

I have an Excel table that has the following (plus more) data in it:

Start data

What I would like to do is filter the data to return all but the columns that have all 0 values in them, i.e. the return would be:

Expected outcome

I can't for the life of me get my filter expression to return what I want, any help would be greatly appreciated!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source