sql - simple way to convert data into columns in ssms -

sql - simple way to convert data into columns in ssms -

this script:

select left(narrkey, 15) business, substring(narrkey, 14, 10) [sales order], substring(narrkey, 24, 3) line, narrline$1 + ' ' + narrline$2 + ' ' + narrline$3 + ' ' + narrline$4 + ' ' + narrline$5 + ' ' + narrline$6 + ' ' + narrline$7 text, case when narrprefix = 'j' 'header text' when narrprefix = 'i' 'line text' else null end expr2 dbo.maa040 (narrlang = 'e') , (narrseq = '000') , (narrprefix = 'j' or narrprefix = 'i')

i want able alter current column narrprefix 2 new columns header text , line text, in 2 new columns have info text column dependent on if header text populate header column or line text populate line column

select left(narrkey, 15) business, substring(narrkey, 14, 10) [sales order], substring(narrkey, 24, 3) line, narrline$1 + ' ' + narrline$2 + ' ' + narrline$3 + ' ' + narrline$4 + ' ' + narrline$5 + ' ' + narrline$6 + ' ' + narrline$7 text, case when narrprefix = 'j' 'header text' when narrprefix = 'i' 'line text' else null end expr2, case when narrprefix = 'j' narrline$1 + ' ' + narrline$2 + ' ' + narrline$3 + ' ' + narrline$4 + ' ' + narrline$5 + ' ' + narrline$6 + ' ' + narrline$7 end headertext, case when narrprefix = 'i' narrline$1 + ' ' + narrline$2 + ' ' + narrline$3 + ' ' + narrline$4 + ' ' + narrline$5 + ' ' + narrline$6 + ' ' + narrline$7 end linetext dbo.maa040 (narrlang = 'e') , (narrseq = '000') , (narrprefix = 'j' or narrprefix = 'i')

sql pivot ssms transpose