In a spare column to the right of the main data (i.e. out of the print
range) add a simple formula to copy the quantity column, eg =G2 if
column G is the quantity column, and copy this down as necessary. Where
you have blanks in column G, these will show as 0 in this helper
column.

Highlight the column and click Data | Filter | Autofilter to turn on
autofilter for this column only. Then, to select only those columns
containing data, you can apply a filter as follows:

Custom | Does Not Equal | 0 (zero)

and only the non-blank rows will be visible.

Hope this helps.

Pete