The SQL column is stitched together into a row, then split into columns

Raw data that needs to be stitched together into one line

SELECT * FROM (select d.*, (select count ([Keyword]) from [dragonguoshi].[ DBO]. [Articleinfo]where Keyword like '% ' +d.keyword+ '% ' and [articlecreatedate]> ' 2018-06-10 ') as Num from (SELECT DISTINCT ( Keyword) from (select SUBSTRING (Keyword,number,charindex (', ', keyword+ ', ', number)-number) as Keyword from (select Stuff (select ', ' +[keyword] from (select [Keyword]from [dragonguoshi].[ DBO]. [Articleinfo]where keyword!= ' and [articlecreatedate]> ' 2018-06-10 ') A FOR XML Path (")), ("), ") as Keyword) B, Master .. Spt_values where
Number >=1 and Number<=len (Keyword)
and type= ' P '
and substring (', ' +keyword,number,1) = ', ') c) d) e where num>20 order by Num Desc

Results

The SQL column is stitched together into a row, then split into columns