SQL Server 2022

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

create table table3(ID int, COLUMN_D varchar(10), COLUMN_E int, COLUMN_F date);
insert into table3 values
 (1,'VALUE1',	10	,'2024-03-01')
,(1,'VALUE1',	11	,'2024-03-02')
,(1,'VALUE2',	10	,'2024-03-01')
,(2,'VALUE1',	15	,'2024-03-01')
,(2,'VALUE2',	12	,'2024-03-01')
,(2,'VALUE2',	12	,'2024-03-02')
;
select * from table3;


ID
COLUMN_D
COLUMN_E
COLUMN_F


1
VALUE1
10
2024-03-01

1
VALUE1
11
2024-03-02

1
VALUE2
10
2024-03-01

2
VALUE1
15
2024-03-01

2
VALUE2
12
2024-03-01

2
VALUE2
12
2024-03-02


select id
  ,max(case when column_d='VALUE1' then column_e end)value1
  ,max(case when column_d='VALUE2' then column_e end)value2
  ,column_f
from table3
group by id,column_f
order by id,column_f;


id
value1
value2
column_f


1
10
10
2024-03-01

1
11
null
2024-03-02

2
15
12
2024-03-01

2
null
12
2024-03-02


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


select id
  ,max(case when column_d='VALUE1' then column_e end)value1
  ,max(case when column_d='VALUE2' then column_e end)value2
  ,column_f,rn
from (
  select *
    ,row_number()over(partition by id,column_f,column_d order by column_f)rn
  from table3
)t
group by id,column_f,rn
order by id,column_f,rn;


id
value1
value2
column_f
rn


1
10
10
2024-03-01
1

1
11
null
2024-03-02
1

2
15
12
2024-03-01
1

2
null
12
2024-03-02
1


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


with t as(
  select *
    ,row_number()over(partition by id,column_f,column_d order by column_f)rn
  from table3
)
select id
  ,max(case when column_d='VALUE1' then column_e end)value1
  ,max(case when column_d='VALUE2' then column_e end)value2
  ,column_f,rn
from (
  select *
    ,row_number()over(partition by id,column_f,column_d order by column_f)rn
  from table3
)t
group by id,column_f,rn
order by id,column_f,rn;


id
value1
value2
column_f
rn


1
10
10
2024-03-01
1

1
11
null
2024-03-02
1

2
15
12
2024-03-01
1

2
null
12
2024-03-02
1


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

ID	COLUMN_D	COLUMN_E	COLUMN_F
1	VALUE1	10	2024-03-01
1	VALUE1	11	2024-03-02
1	VALUE2	10	2024-03-01
2	VALUE1	15	2024-03-01
2	VALUE2	12	2024-03-01
2	VALUE2	12	2024-03-02

id	value1	value2	column_f
1	10	10	2024-03-01
1	11	null	2024-03-02
2	15	12	2024-03-01
2	null	12	2024-03-02