I reckon you should change your original query to something along these lines:

SELECT condition AS ColumnA, COALESCE(SUM(Total), 0) AS ColumnB
FROM yourTable
WHERE condition IN ('A', 'B', ...)
GROUP BY condition;

Below Query will help you:

Drop table if exists #TempYourTable
CREATE table #TempYourTable (COLUMN_NAME nvarchar(500), COLUMN_VALUE nvarchar(max))

insert into #TempYourTable (COLUMN_NAME) 
select COLUMN_NAME 
from
(
    SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'yourTable'
) as tbl_col_nm

Declare @Query nvarchar(max);
SELECT 
    @Query = ISNULL(@Query +';', '') + ISNULL('update #TempYourTable set COLUMN_VALUE = (select top 1 '+ isnull(T.COLUMN_NAME,'')+' from yourTable) where COLUMN_NAME = '''+T.COLUMN_NAME+'''', '')
FROM 
( 
    select COLUMN_NAME as COLUMN_NAME    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = N'yourTable'
)T

print @Query
Exec(@Query) 

select * from #TempYourTable

This is just a simple unpivot:

select col, value
from (
    VALUES  (N'Value 1', N'Value 2', N'Value 3', N'Value 4', N'Value 5', N'Value 6')
) t ([Title A],[Title B],[Title C],[Title D],[Title E],[Title F])
unpivot (value for col in ([Title A],[Title B],[Title C],[Title D],[Title E],[Title F])) upv

If you want dynamic one, there are plenty of answers available