How does one transpose a group of columns into rows?

[Jacob, Raymond A Jr]

I have a table:


Id  |path1  | display| value
1  | ostype |  os    |windows
1  | ostype | ver     |NT4
2  | ostype | os   |  linux
2  | ostype | ver   | RHEL 5.4
That I would like to tranform into

Id | os        | ver 
1 |windows | NT4
2| linux       |RHEL 5.4

Thank you,
Raymond

smime.p7s
Description: S/MIME cryptographic signature