Solved: Horizantal Fields To Vertical Fields Conversion

[akn112]

My table has 3 fields: fruit, parameter name, parameter value.
The problem is, i want the parameter name to define the fields in a new table. Example.

[vba]
Fruit Parameter Name Parameter Value
Apple Color Red
Apple Taste 4
Apple Quantity 3
Orange color Orange
Orange Taste 3
Orange Quantity 5
Orange Price Code 4

needs to look like

Fruit Color Taste Quantity Price Code
Apple Red 4 3
Orange Orange 3 5 4
[/vba]

I"ve been trying to use an append query to append to a new table with predefined fields (i already know what parameters i need to extract) but have found it difficult . For example, even though the parameter name includes color, quantity, taste, but sometimes i only want to use color and quantity as the vertical fields. Attached is a sample to test with. Thanks!