Pivot table Query - Need help in building correct logic

From: Pankaj <harpreet.noni_at_gmail.com>
Date: Thu, 3 Dec 2009 15:36:29 -0800 (PST)
Message-ID: <15df6133-045a-4a4f-88b5-89195be763e4_at_e22g2000vbm.googlegroups.com>


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

Original text of this message