with basedata (
    name,
    addy,
    ph,
    grade
) as (
select
    name,
    addy,
    ph,
    grade1
from
    sourcetable
union all
select
    name,
    addy,
    ph,
    grade2
from
    sourcetable
union all
select
    name,
    addy,
    ph,
    grade3
from
    sourcetable
union all
select
    name,
    addy,
    ph,
    grade4
from
    sourcetable
union all
select
    name,
    addy,
    ph,
    grade5
from
    sourcetable
)
INSERT INTO dest_table(
    name,
    addy,
    ph,
    grade
)
select
    name,
    addy,
    ph,
    grade
from
    BaseData
where
    grade is not null;

SELECT name,addy,ph,subject,grade
FROM #test CROSS APPLY (VALUES('subject 1',grade1),('subject 2',grade2),('subject 3',grade3),('subject 4',grade4),('subject 5',grade5)) AS x(subject,grade)