I have a cursor with 3 fields order_key, lup_type, lup_value.
The data might look as follows:
531 make FORD
531 color BLUE
532 make HONDA
532 color RED
533 color ORANGE (person didn't enter a car make)
534...etc.

These values were already retrieved from a vehicle_info table and a lookup table.

How can I take these values and combine them so that it will have the following layout:

order_key, veh_make, veh_color
531, FORD, BLUE
532, HONDA, RED
533, , ORANGE

I tried a self join but can't get the list to show unique order_key's.

As always, thanks for your excellent help.

Marcel