SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE YourTable (
    ColumnA varchar(50),
    ColumnB varchar(50),
    ColumnC varchar(50),
    ColumnD varchar(50),
    ColumnE varchar(50)
);
INSERT INTO YourTable (ColumnA, ColumnB, ColumnC, ColumnD, ColumnE)
VALUES
('Jacob', 'Joseph', 'Ben', NULL, NULL),
('Jacob', 'Joseph', NULL, NULL, 'Reuben'),
('Jacob', 'Joseph', NULL, 'Judah', NULL);
3 rows affected

SELECT * FROM YourTable


ColumnA
ColumnB
ColumnC
ColumnD
ColumnE


Jacob
Joseph
Ben
null
null

Jacob
Joseph
null
null
Reuben

Jacob
Joseph
null
Judah
null


SELECT 
    ColumnA,
    ColumnB,
    MAX(ColumnC) AS ColumnC,
    MAX(ColumnD) AS ColumnD,
    MAX(ColumnE) AS ColumnE
FROM 
    YourTable
GROUP BY 
    ColumnA, ColumnB;


ColumnA
ColumnB
ColumnC
ColumnD
ColumnE


Jacob
Joseph
Ben
Judah
Reuben


Warning: Null value is eliminated by an aggregate or other SET operation.

ColumnA	ColumnB	ColumnC	ColumnD	ColumnE
Jacob	Joseph	Ben	null	null
Jacob	Joseph	null	null	Reuben
Jacob	Joseph	null	Judah	null