Pivot table Query - Need help in building correct logic

I have a table format as below

sec       value        type
X          100           T
X          200           S
Y         300            T
Y         400            S
Z          500           T
Z          600           S

I want to pivot the above to somethin as below

sec     T           S
X        100        200
Y        300       400
Z        500        600

Can anyone please advise. I have been looking for pivot logic for some time but could not figure this out.

TIA Received on Thu Dec 03 2009 - 17:36:29 CST