with [tmp] as (select 'test' as [name], 1 as [mesto], 3 as [qty] 
             union all 
             select 'test' as [name], 2 as [mesto], 2 as [qty]
             union all             
             select 'test' as [name], 3 as [mesto], 1 as [qty]
             union all             
             select 'test' as [name], 3 as [mesto], 2 as [qty]
             union all
             select 'test1' as [name], 1 as [mesto], 5 as [qty] 
             union all 
             select 'test1' as [name], 2 as [mesto], 3 as [qty]
             union all             
             select 'test1' as [name], 3 as [mesto], 5 as [qty]
             union all             
             select 'test1' as [name], 3 as [mesto], 7 as [qty])                                        
                                                    
 select [t].[name],
         sum(case when [t].[mesto] = 1 then [t].[qty] end) as [mesto1],
         sum(case when [t].[mesto] = 2 then [t].[qty] end) as [mesto2],
         sum(case when [t].[mesto] = 3 then [t].[qty] end) as [mesto3]
    from [tmp] [t]
group by [t].[name]