condensing a disjointed table, with lookups

[mgolay]

hi there,

i'm trying to take a table of disjointed data, and segregate the 'true' items into 1 final condensed table; hopefully in order or their appearance in the original.
the final table would make a better reference using vlookup, etc.
excel 2010 btw.

an example is in the attachment; i'd like to get the final yellow table to reference. here it is copy & pasted in txt..not sure if the spaces are going to process accordingly in the thread...
A B C D
1| produce variety color
2| =if(color)="red", True, false
3| Apples mcintosh red TRUE
4| Apples gala red & white FALSE
5| Apples grannysmith green FALSE
6| Apples red delicious red TRUE
7|
8| =if(color)="yellow",true,false
9| Corn Taber yellow TRUE
10| Corn Maize multi FALSE
11| Corn Sweet yellow TRUE
12| Corn Peaches & cream yellow TRUE


ref table - red & color produce ("Trues")

Mcintosh Apple red
Red Delicious Apple red
Taber Corn yellow
Sweet Corn yellow
Peaches & Cream Corn yellow

how would i get this final table condensed down; then i can use hlookup, or index, etc.?

thanks for any input; and eat your vegetables - they're good for you!

[vlady]

You could provide a real workbook instead of pictures.

[mgolay]

thanks! good idea to attach the excel.

note that there may be blanks between rows, etc.