Auto-deleting cells

[markbreakspear]

Hi everyone, hope someone can help.
I need to create a summary of an equipment list (sheet 1) into a quote format on sheet 2. Therefore any equipment not with a quantity (blank cell on sheet 1), needs to be deleted from the quote.
i.e.
(Sheet1) Quantity required
Product A 2
Product B
Product C
Product D 1
Product E
Product F 5

(sheet2)
Product A 2
Product D 1
Product F 5

Any ideas?!

[royUK]

You could just filter the products, only visible cells will print.

Attach a workbook