Transpose rows to columns

Hi everybody,

Can anybody look into my problem? The problem is to transpose columns to rows dynamically.

The original table is -

Proj Prot Pid Labcode Result

001    1    1     HGB      100.00
001    1    1     RBC      200.00
001    1    1     HCT      300.00
001    1    2     HGB      150.00
001    1    2     HCT      112.00
001    1    2     RBC      150.00
001    1    2     XYZ      102.00

So, there could be say 50 labcodes vertically for each pid.

Now, the above has to be transposed to -

Proj   Prot  Pid   HGB     RBC     HCT      XYZ
001     1     1    100.00  200.00  300.00   Null
001     1     2    150.00  150.00  112.00   102.00

Any help/hints is appreciated.

Thanks!

Abhijit

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 02 1998 - 12:44:00 CST