Denormalizing a database table

Folks,

Any help with creating a SP that denormalizes the below table to the desired output will be appreciated.

Current Input Table Structure:

SNum KeyName KeyVal value

1     SCM1    name    DFW
1     SCM1    OVal   200
1     SCM1    OSum   500
2     SCM2    name    ORL
2     SCM2    OVal   100
2     SCM2    OSum   200
3     SCM1    name    DFW
3     SCM1    OVal   100
3     SCM1    OSum   100

Desired O/p in a secondary temp table

DFW 200 500
ORL 100 200
DFW 100 100 Rgds
Alk Received on Wed Aug 09 2006 - 14:09:21 CDT