Im displaying tables side by side for reporting purposes. Some of the rows in each table come up with "0"s. I would like to filter out the rows with "0" from the left table without hiding the information on the same row on the table to the right, as well as visa versa. Is there a even a way to do this? Crazy ideas welcome.

Thanks,
Cliff
(Excel for Mac 2011)