List only cell with Values

Hello,

I'm fairly new to the Excel world, so have no understanding of VB, I've been working thus far in simple cell formulas, however I have a problem and I just can't work out what to do.. Please help someone..

I have a spreadsheet with a list of products in Column A. Column B is Quantity. The user will fill out a sheet on the same workbook which will autopopulate the Quantity column, i.e. there is a formula in every Quantity cell.

For all the Products that have a quantity, i.e. not 0, I want to copy the Product and Quantity and provide it in a list format on another sheet, with no row gaps..

i.e.

Product A,1
Product B,0
Product C,0
Product D,1

would produce a list

Product A,1
Product D,1

Anyhelp anyone could provide I would really really appreciate.

Thanks, Janet