Table Dynamic Filter

Hi All,

I have a table with several rows and columns.

I want to copy the table and on the copied table have rows where the value of a column is zero (Column G) hidden (Or deleted)

I can do that by copying the table and use filter to that column and make the filter NOT-show zero values.

But I want it to be dynamic - ie any time values are changed / updated on the main table has to be corresponding values updated on the second one as well.

The attached sheet shows on table 1 the original table and on table 2 the required table.

I was thinking a conditional Index match would do the job but couldn't make it work.

Thanks.