SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab1 (
  [id] VARCHAR(7),
  [value] VARCHAR(5)
);

INSERT INTO tab1
  ([id], [value])
VALUES
  ('1', 'music'),
  ('2', NULL),
  ('3', 'movie'),
  ('4', NULL),
  ('5', NULL),
  ('6', 'book'),
  ('7', NULL),
  ('8', NULL);

















8 rows affected

WITH atab1 AS (
SELECT [id], [value] from tab1 WHERE [id] BETWEEN 1 ANd 5)
Update a Set
    a.[value]  = b.[value] 
From
    atab1 As a    
    Cross Apply (
        Select Top 1 [value] 
        From tab1 
        Where 
            ( [id] < a.[id] ) 
            And ( a.[value]  Is Null ) 
            And ( [value]  Is Not Null ) 
        Order By [id] Desc
    ) As b
3 rows affected

SELECT * FROM tab1


id
value


1
music

2
music

3
movie

4
movie

5
movie

6
book

7
null

8
null


WITH atab1 AS (
SELECT [id], [value] from tab1 WHERE [id] BETWEEN 3 ANd 8)
Update a Set
    a.[value]  = b.[value] 
From
    atab1 As a    
    Cross Apply (
        Select Top 1 [value] 
        From tab1 
        Where 
            ( [id] < a.[id] ) 
            And ( a.[value]  Is Null ) 
            And ( [value]  Is Not Null ) 
        Order By [id] Desc
    ) As b
2 rows affected

SELECT * FROM tab1


id
value


1
music

2
music

3
movie

4
movie

5
movie

6
book

7
book

8
book