Moving data from two columns into many

[Vehil]

Hi
I'm having trouble moving my cells from two columns into multiple.
Basically looks like this:

Fruit	Apple
Taste	Crunchy, delicious
Fruit	Banana
Taste	Mushy, disgusting
Fruit	Orange
Taste	Sweet, tangy
Colour
Fruit	Pineapple
Taste
Colour	Grey

And I basically want it to have all the different categories across the top so:

Fruit	Taste	Colour
Apple	Crunchy, delicious
Banana	Mushy, disgusting
Orange	Sweet, tangy
Pineapple		Grey

So there's blanks in some cells. Here's what I've done so far: http://i.imgur.com/EkSzHG9.png
Any ideas?

 

[Vehil]

I guess the way to do it is to:
Find 'Fruit' in A:A and print B:B in Column 1.
then find Taste in A:A and print B:B in Column 2.

This is what I've done in my example but I can't figure out how to print it in the box directly below, rather than the same row it was found in.

 

[s7726]

Looks like your looking for an array formula.