SQL Server 2019

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

CREATE TABLE tableA (id int, 
                     year varchar(10),
                     nb int)
                     
INSERT INTO tableA VALUES                     
                         (1, '2018', 10),
                         (2, '2018', 3),
                         (3, '2019', 108),
                         (2, '2019', 873),
                         (2, '2020', 42),
                         (1, '2019', 53),
                         (3, '2018', 423);
7 rows affected

select * from tableA


id
year
nb


1
2018
10

2
2018
3

3
2019
108

2
2019
873

2
2020
42

1
2019
53

3
2018
423


SELECT id,
[2018] AS nb_2018,
[2019] AS nb_2019,
[2020] AS nb_2020
FROM
(
  SELECT *
  FROM tableA
)AS Source
PIVOT
(sum(nb)
FOR year in ([2018], [2019], [2020])
)as pvtable


id
nb_2018
nb_2019
nb_2020


1
10
53
null

2
3
873
42

3
423
108
null