if object_id('tempdb..#tbl') is not null drop table #tbl
Create table #tbl  (City nvarchar(max),t_date date,value int)

insert #tbl
values('Kazan','01.06.16',11),
 ('Kazan','01.05.16',12),
 ('Kazan','01.04.16',13),
 ('Kazan','01.03.16',14),
 ('Kazan','01.02.16',15),
 ('Kazan','01.01.16',16),
 ('Kazan','01.12.15',17),
 ('Kazan','01.11.15',18),
('Chelny','01.06.16',23),
('Chelny','01.05.16',24),
('Chelny','01.04.16',25),
('Chelny','01.03.16',26),
('Chelny','01.02.16',27),
('Chelny','01.01.16',28),
('Chelny','01.12.15',29),
('Chelny','01.11.15',30)

DECLARE @cols AS NVARCHAR(MAX),
    @query  AS NVARCHAR(MAX);

select @cols =  COALESCE(@cols + ', ', '') + QUOTENAME(cast(t_date as varchar)) 
from (select distinct t_date from #tbl) a order by t_date desc

set @query = 'SELECT City, ' + @cols + ' from 
            (
                select City
					,t_date
					,value                  
               
                from #tbl
           ) x
            pivot 
            (
                 max(value)
                for t_date in (' + @cols + ')
            ) p '

print @query

execute(@query)