select groupid,max(type1qty)as type1_qty,max(type1reason)as type1_reason,max(type2qty)as type2_qty,max(type2reason)as type2_reason
from (
select groupid,([type1]) as type1qty,([type2]) as type2qty,null  as type1reason,null as type2reason
from @tab
pivot (max(qty) for type in ([type1],[type2]))p
union 
select groupid,null,null,([type1]),([type2]) 
from @tab
pivot (max(reason) for type in ([type1],[type2]))p
)s
group by groupid

select groupid,
max(case when type = 'type1' then qty end) as 'type1_qty',
max(case when type = 'type1' then reason end) as 'type1_reason',
max(case when type = 'type2' then qty end) as 'type2_qty',
max(case when type = 'type2' then reason end) as 'type2_reason'
from tablename
group by groupid