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:

=IF(B2=extract!B$1,MAX(D$1:D1)+1,"-")

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:

=IFERROR(INDEX(raw_data!A:A,MATCH(ROWS($1:1),raw_data!D:D,0)),"")

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.