Copy to new sheet without blank rows

Hi all - Love your work.

In the attached file, I need to extract the data from the "data" sheet and paste onto the "test" sheet. Commodities must remain in the order they are (Alpha), however I do not wish to copy the rows with blanks in the totals column.
Each month the data is updated and the blank totals will change. So currently, the first would be 3/4LD, Apples etc. Next month might be Beer first.
Formulas and Array Formulas are fine, but cannot use coded macros.

Any help appreciated.

Thanks

you can filter by total for those amount that are not zero within tab DATA, then paste value in tab TEST

Yes that is an option, however I am trying to automate it so that I just have to paste the monthly data in and it works it out itself.

Ok I think I have it worked out. Can someone please point out if there are any errors in the formula entered.