Combining many rows to one

I have a table from another application which is of the form primary key code-no value. I need it in the unnormalised form of primary key code_a code_b code_x value_a value_b value_x Any pointers as to how to do this in ISQL? Thanks, Kate