Hi,

Have you tried using UNPIVOT in sql2005? I hope this is what you are looking for. 🙂

SELECT SIDNO, SUBID, GRADES

FROM (

SELECT SIDNO, AO101, BT101, CH101, ES101, TA101, PH101, MA101

FROM...