I'm trying to see if there is a formula to use to condense a list. Quickest
example would be a shopping list. the sheet1 is as follows:

Desc. Name Qty.
Ice Tea Minute Maid
Milk Daily Farms
Cookies Chip Ahoy
Veggies Carrots

What I would like to happen is if in Sheet1 there is a quantity next to an
Item, have that entire row appear on sheet2. Sheet2 would then give me a
result of just items with quanties. Can anyone help?