create table t ([Type] int,Test char(1),Min int,Max int)

insert into t values

 (1,'a',1,2)

,(1,'b',Null,Null)

,(2,'a',0,Null)

,(2,'b',Null,1)

​

​

select 

    [Type]

  , Test_1     = max(case when rn = 1 then Test end)

  , Test_1_Min = max(case when rn = 1 then Min  end)

  , Test_1_Max = max(case when rn = 1 then Max  end)

  , Test_2     = max(case when rn = 2 then Test end)

  , Test_2_Min = max(case when rn = 2 then Min  end)

  , Test_2_Max = max(case when rn = 2 then Max  end)

from (

  select *

    , rn = row_number() over (partition by [Type] order by [Test]) 

  from t

  ) as s

group by s.Type