unpivot과 case 참고요.. 

with tmp as (

select 1 as c0, cast('가은' as varchar(50)) as c1, cast('고덕초등학교' as varchar(50)) as c2, cast('안심' as varchar(50)) as c3, cast('1/2' as varchar(50)) as c4, cast('10kg' as varchar(50)) as c5, cast('잘부탁합니다.' as varchar(50)) as c6 union all

select 2, '가은', '고덕초등학교', '안심', '2/2', '10kg', '' union all

select 3, '은성', '김해경원고등학교', '가슴살', '1/1', '10kg', '잘부탁합니다.'

)

select

c0,

val,

n1

from tmp

unpivot(n1 for val in (c1, c2, c3,c4, c5, c6)) as nx ;

with tmp as (

select 1 as c0, '가은' as c1, '고덕초등학교' as c2, '안심' as c3, '1/2' as c4, '10kg' as c5, '잘부탁합니다.' as c6 union all

select 2, '가은', '고덕초등학교', '안심', '2/2', '10kg', '' union all

select 3, '은성', '김해경원고등학교', '가슴살', '1/1', '10kg', '잘부탁합니다.'

), nums AS (

SELECT 1 as n

UNION ALL

SELECT n + 1 FROM nums

WHERE n < 6

)

select

c0,

case n when 1 then 'c1'

when 2 then 'c2'

when 3 then 'c3'

when 4 then 'c4'

when 5 then 'c5'

when 6 then 'c6'

end as new_c,

case n when 1 then c1

when 2 then c2

when 3 then c3

when 4 then c4

when 5 then c5

when 6 then c6

end as new_v

from

tmp a

cross join nums

order by c0 ;