Matrix output

;WITH cteChannel AS (
SELECT ID
  FROM @T
 WHERE Code = 'CHN'
), cteDrug AS (
SELECT ID
  FROM @T
 WHERE Code = 'DRG'
), cteTerm AS (
SELECT ID
  FROM @T
 WHERE Code = 'term'
)
SELECT *
  FROM cteChannel, cteDrug, cteTerm

J.