CREATE TABLE #myTable99(Col1 char(3), Col2 varchar(256), Col3 int, Col4 int, Col5 int)
GO

INSERT INTO #myTable99(Col1, Col2, Col3, Col4, Col5)
SELECT 'G01', 'Hardy Rural Families Remote America',	224,  224,  356133 UNION ALL
SELECT 'G02', 'Rural Southern Living Remote America',	NULL, 224,  356133 UNION ALL
SELECT 'G03', 'Coal and Crops Remote America',			NULL, 224,  356133 UNION ALL
SELECT 'G04', 'Native Americans Remote America',		NULL, NULL, NULL
GO

SELECT a.Col1, a.Col2, b.Col3, b.Col4, b.Col5
FROM #myTable99 a
JOIN (SELECT MIN(Col3) AS Col3, MIN(Col4) AS Col4, MIN(Col5) AS Col5 FROM #myTable99) AS b 
ON 1=1
GO

DROP TABLE #myTable99
GO