Thanks guys.... i worked it out... now, if i were to turn the select into an insert statement?

with basedata (

name,

addy,

ph,

grade

) as (

select <--PUT INSERTS HERE?

name,

addy,

ph,

grade1

from

sourcetable

union all

select

name,

addy,

ph,

grade2

from

sourcetable