SQL Server 2017

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

create table test1(
idx int,
name varchar(30),
att_date date,
att_entry datetime,
att_out datetime,
overtime int
);



insert into test1 values
(26, 'ShiftCC1', '01-03-2022',	'01-03-2022 09:10', '01-03-2022 18:10',	1),
(26, 'ShiftCC1', '02-03-2022',	'02-03-2022 09:15', '02-03-2022 18:15',	2),
(26, 'ShiftCC1', '03-03-2022',	'03-03-2022 09:05', '03-03-2022 18:05',	2),
(26, 'ShiftCC1', '04-03-2022',	'04-03-2022 09:10', '04-03-2022 18:10',	1),
(26, 'ShiftCC1', '05-03-2022',	'05-03-2022 09:13', '05-03-2022 18:13',	2),
(26, 'ShiftCC1', '06-03-2022',	'06-03-2022 09:14', '06-03-2022 18:14',	3),
(26, 'ShiftCC1', '07-03-2022',	'07-03-2022 09:16', '07-03-2022 18:16',	2),
(26, 'ShiftCC1', '08-03-2022',	'08-03-2022 09:30', '08-03-2022 18:30',	1),
(26, 'ShiftCC1', '09-03-2022',	'09-03-2022 09:20', '09-03-2022 18:20',	2),
(26, 'ShiftCC1', '10-03-2022',	'10-03-2022 09:25', '10-03-2022 18:25',	3);
10 rows affected

create view test2
as select idx, name as name, convert(varchar, att_date) as att_date,
convert(varchar, att_entry) as att_entry,
convert(varchar, att_out) as att_out,
convert(varchar, overtime) as overtime
from test1;
DECLARE @cols AS NVARCHAR(MAX),
    @query  AS NVARCHAR(MAX);

SET @cols = STUFF((SELECT distinct ',' + QUOTENAME(c.att_date) 
            FROM test2 c
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)') 
        ,1,1,'')

set @query = 'SELECT idx, name, ' + @cols + ' from 
            (
                select idx,
                       name,
                    att_date,
                    overtime
                from test2
           ) x
            pivot 
            (
                 max(overtime)
                for att_date in (' + @cols + ')
            ) p 
            union 
            SELECT idx, name, ' + @cols + ' from 
            (
                select idx,
                       name,
                    att_date,
                    att_out
                from test2
           ) x
            pivot 
            (
                 max(att_out)
                for att_date in (' + @cols + ')
            ) p 
            union 
            SELECT idx, name, ' + @cols + ' from 
            (
                select idx,
                       name,
                    att_date,
                    att_entry
                from test2
           ) x
            pivot 
            (
                 max(att_entry)
                for att_date in (' + @cols + ')
            ) p order by 3 desc'
            


execute(@query)


idx
name
2022-01-03
2022-02-03
2022-03-03
2022-04-03
2022-05-03
2022-06-03
2022-07-03
2022-08-03
2022-09-03
2022-10-03


26
ShiftCC1
Jan  3 2022  9:10AM
Feb  3 2022  9:15AM
Mar  3 2022  9:05AM
Apr  3 2022  9:10AM
May  3 2022  9:13AM
Jun  3 2022  9:14AM
Jul  3 2022  9:16AM
Aug  3 2022  9:30AM
Sep  3 2022  9:20AM
Oct  3 2022  9:25AM

26
ShiftCC1
Jan  3 2022  6:10PM
Feb  3 2022  6:15PM
Mar  3 2022  6:05PM
Apr  3 2022  6:10PM
May  3 2022  6:13PM
Jun  3 2022  6:14PM
Jul  3 2022  6:16PM
Aug  3 2022  6:30PM
Sep  3 2022  6:20PM
Oct  3 2022  6:25PM

26
ShiftCC1
1
2
2
1
2
3
2
1
2
3

idx	name	2022-01-03	2022-02-03	2022-03-03	2022-04-03	2022-05-03	2022-06-03	2022-07-03	2022-08-03	2022-09-03	2022-10-03
26	ShiftCC1	Jan 3 2022 9:10AM	Feb 3 2022 9:15AM	Mar 3 2022 9:05AM	Apr 3 2022 9:10AM	May 3 2022 9:13AM	Jun 3 2022 9:14AM	Jul 3 2022 9:16AM	Aug 3 2022 9:30AM	Sep 3 2022 9:20AM	Oct 3 2022 9:25AM
26	ShiftCC1	Jan 3 2022 6:10PM	Feb 3 2022 6:15PM	Mar 3 2022 6:05PM	Apr 3 2022 6:10PM	May 3 2022 6:13PM	Jun 3 2022 6:14PM	Jul 3 2022 6:16PM	Aug 3 2022 6:30PM	Sep 3 2022 6:20PM	Oct 3 2022 6:25PM
26	ShiftCC1	1	2	2	1	2	3	2	1	2	3