Lita
Select the entire range of your data. Click on Data - Filter -
AutoFilter. A down-arrow will appear to the right of each header. Click
the down-arrow in the Qty header. One of the options available is
"Non-Blanks". Click on it. That hides all the blank Qty rows. Copy
everything and paste it to the next sheet. Back on your first sheet, click
on Data - Filter - Autofilter to make everything visible again. HTH Otto
"Lita" wrote in message
...
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?