CREATE TABLE #TEMP(Time varchar(50),Atl_1 int, Atl_2 int, Atl_3 int, NY_1 int, NY_2 int)
INSERT INTO #TEMP
VALUES
('02/12' , 300,120 ,550, 548, 784)
,('02/13' , 140,100 ,720, 369, 985);
DECLARE @query nvarchar(max),@list varchar(max)='Atl_1,Atl_2,Atl_3,NY_1,NY_2';
WITH CTE AS(
select DISTINCT
Stuff((select DISTINCT '+SUM('+value+')' from string_split(@list,',') as dd where dd.value like '%'+substring(ss.value,1,charindex('_',ss.value))+'%' for xml path('')),1,1,'')+' AS '+substring(ss.value,1,charindex('_',ss.value))+'ALL' as pcols FROM string_split(@list,',') as ss
)
SELECT @list=Stuff((select ','+Pcols from CTE for XML Path('')),1,1,'')
SET @query=N'select time,'+@list+' from #TEMP GROUP BY time';
EXEC(@query);