This would work for the data you've given:

USE [tempdb]

--== SAMPLE DATA ==--

IF OBJECT_ID('tempdb..#Servers') IS NOT NULL DROP TABLE #Servers

CREATE TABLE #Servers

(

ServerNameVarchar(25) NULL,

sybaseVarchar(25) NULL,

MQVarchar(25) NULL,

CitrixfarmVarchar(25) NULL,

oracleVarchar(25) NULL,

UDBWVarchar(25) NULL,

IHSVarchar(25) NULL,

WASVarchar(25) NULL

)

INSERT #Servers

(ServerName, sybase, MQ, Citrixfarm, oracle, UDBW, IHS, WAS)

VALUES

('ABC1234', '6.2.5.0', NULL, NULL, NULL, '6.2.5.0', NULL, '2.7.6.3')

INSERT #Servers

(ServerName, sybase, MQ, Citrixfarm, oracle, UDBW, IHS, WAS)

VALUES

('ABC1234', NULL, '3.8.88.9', NULL, '5.6.7.8', NULL, NULL, NULL)

SELECT * FROM #Servers

--== SUGGESTED SOLUTION ==--

SELECT ServerName,

sybase = MAX(sybase),

MQ = MAX(MQ),

Citrixfarm = MAX(Citrixfarm),

oracle = MAX(oracle),

UDBW = MAX(UDBW),

IHS = MAX(IHS),

WAS = MAX(WAS)

FROM #Servers

GROUP BY ServerName

ORDER BY ServerName