SQL Server 2019

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

select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64) 
 Apr 11 2022 16:24:07 
 Copyright (C) 2019 Microsoft Corporation
 Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



create table jobs (
job_id int,
change_id int,
changes varchar(max)
);

insert into jobs values 
(1,	1,	'5'),
(1,	1,	'6'),
(1,	1,	''),
(1,	1,	'7'),
(1,	1,	'8'),
(1,	1,	''),
(1,	2,	'9'),
(1,	2,	'10'),
(1,	2,	''),
(2,	3,	'1'),
(2,	3,	'3'),
(2,	3,	'');
12 rows affected

SELECT 
    *,
    '' blank
FROM (    
    SELECT 
        job_id,
        change_id,
        changes AS changes_from,
        LEAD(changes) OVER (PARTITION BY job_id, change_id ORDER BY job_id) AS changes_to
   FROM jobs
) j
WHERE changes_from != '' AND changes_to != ''


job_id
change_id
changes_from
changes_to
blank


1
1
5
6


1
1
7
8


1
2
9
10


2
3
1
3