SELECT RTRIM(
          + 'ColA:'+ISNULL(ColA,'')+', '
          + ISNULL('ColB:'+CAST(ColB AS VARCHAR(10))+' ','')
          + ISNULL('ColC:'+CAST(ColC AS VARCHAR(10))+' ','')
          + ISNULL('ColD:'+CAST(ColD AS VARCHAR(10))+' ','')
        )
   FROM
( --=== Similation of your table.  Use your table name here
 SELECT 'Admin',NULL,NULL,NULL UNION ALL
 SELECT 'Market',101,256,258 UNION ALL
 SELECT 'Sales',205,125,NULL UNION ALL
 SELECT 'Admin',256,258,548
)d(ColA,ColB,ColC,ColD)
;

SELECT RTRIM(
+ ISNULL(Col_Name, '') + ' : '
+ ISNULL(CAST(ColB AS VARCHAR(10)) + ' ', '')
+ case when ColB IS NULL then NULL else ISNULL(' ColC :' + CAST(ColC AS VARCHAR(10)) + ' ', '') end
) FROM table_name