SQL Server 2019

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

create table t(OrderID int,	Topic varchar(50), 	hierarchyLevel int,	Responsible_Person varchar(50), 	Status varchar(50))
insert into t select 1234	, 'A',	0, 'Jason','Open'
insert into t select 1234	, 'A',	0, 'Carol','Open'
insert into t select 1234	, 'A',	1, 'Jeff','Open'
insert into t select 1234	, 'A',	2, 'Alina','Open'
insert into t select 1234	, 'A',	3, 'Eileen','Open'
insert into t select 1234	, 'B',	0, 'John','Closed'
insert into t select 1234	, 'B',	1, 'Danny','Open'
insert into t select 1234	, 'B',	1, 'Celine','Open'
insert into t select 1234	, 'B',	2, 'Corry','Open'
insert into t select 1234	, 'B',	3, 'Logan','Open'
insert into t select 1234	, 'C',	0, 'Jason','Closed'
insert into t select 1234	, 'C',	1, 'Annisa','Open'
insert into t select 1234	, 'C',	2, 'Cedric','Open'
insert into t select 1234	, 'D',	0, 'Peter','Closed'
insert into t select 1234	, 'D',	1, 'Joanna','Closed'
insert into t select 1234	, 'D',	2, 'Freeke','Open'
insert into t select 1234	, 'E',	0, 'Carol','Closed'
insert into t select 1234	, 'E',	1, 'Cynthia','Closed'
insert into t select 1234	, 'E',	2, 'Deidra','Open'

19 rows affected

OrderID	Topic	hierarchyLevel	Responsible_Person	Status
1234	A	0	Jason	Open
1234	A	0	Carol	Open
1234	B	1	Danny	Open
1234	B	1	Celine	Open
1234	C	1	Annisa	Open
1234	D	2	Freeke	Open
1234	E	2	Deidra	Open