List items to new sheet which match specific criteria

I'm looking to list only those items which match a specified criteria to a new sheet.

For example;

Orange	Fruit
Apple	Fruit
Milk	Dairy
Tomato	Fruit
Cheese	Dairy
Beef	Meat
Pear	Fruit

On a new sheet, I want to be able to list only those items which are fruit.

Orange

Apple

Tomato

Pear

I could see if I used IF, but then I'd get blank rows in my sheet, which I don't want.

Any ideas of how I can accomplish this?

Thanks kindly.

I've set this up for you in the attached file. In the raw_data sheet I've added a formula to the helper column (D), which is copied down beyond your data (the hyphens help to show how far). D2 contains this formula:

Formula:

Please Login or Register  to view this content.

In the extract sheet I have set up a data validation drop-down in B1, where you can select the category you are interested in. Then in B3 I have this formula:

Formula:

Please Login or Register  to view this content.

which is copied down as far as you think you need it to be.

Now, just select a category in B1 and the data will automatically change.

Hope this helps.

Pete

Thank you kindly, that did the trick.