Dan, I think Lynn's solution is probably better, but just for academic purposes, you could try something like this...

IF OBJECT_ID('tempdb..#test','u') IS NOT NULL

DROP TABLE #test;

SELECT

'Dan' AS [name],

'123 Main' AS addy,

'555-5555' AS ph,

CAST('A' AS VARCHAR(20)) AS grade1,

CAST(NULL AS VARCHAR(20)) AS grade2,

CAST('C+' AS VARCHAR(20)) AS grade3,

CAST(NULL AS VARCHAR(20)) AS grade4,

CAST(NULL AS VARCHAR(20)) AS grade5

INTO #test;

SELECT

[name],addy,ph,grade

FROM

(

SELECT

[name],

addy,

ph,

grade1,

grade2,

grade3,

grade4,

grade5

FROM #test) t

UNPIVOT

(

grade

FOR x IN ([grade1],[grade2],[grade3],[grade4],[grade5])

) AS unpvt

WHERE grade IS NOT NULL