Assume the listing of data below:


Num Name Tx Ok Ks
1 Smith 10 15 18
2 Jones 12 14 16
3 Brown 82 500 65
4 White 111 80 60
5 Pinkerton 75 65 55


I need a method to transform as shown below:

1 Smith Tx 10
1 Smith Ok 15
1 Smith Ks 18

and then continue for each subsequent name record above. Basically you are
extracting the state column name and the value from that state's column and
creating another record.

The desire and intent is not to use a macro. I figured a pivot table would
accomplish that, but I haven't been able to figure out how yet.

Thanks,