The best way to do this depends very much on how you want the View to behave.
However,
=IF(FILTERNAME()="Hide Column","",{Value})
and then giving the column the attribute to AutoHide is a simple approach. A column with the AutoHide attribute will be hidden if it contains all zeros or spaces.