SQL Server 2017

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

10 rows affected

DECLARE @cols AS NVARCHAR(MAX),
    @query  AS NVARCHAR(MAX);

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

set @query = 'SELECT idx, name, ' + @cols + ' from 
            (
                select idx,
                       name,
                    att_date,
                    att_entry
                from test1
           ) x
            pivot 
            (
                 max(att_entry)
                for att_date in (' + @cols + ')
            ) p 
            union 
            SELECT idx, name, ' + @cols + ' from 
            (
                select idx,
                       name,
                    att_date,
                    att_out
                from test1
           ) x
            pivot 
            (
                 max(att_out)
                for att_date in (' + @cols + ')
            ) p '

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	2022-01-03 09:10:00.000	2022-02-03 09:15:00.000	2022-03-03 09:05:00.000	2022-04-03 09:10:00.000	2022-05-03 09:13:00.000	2022-06-03 09:14:00.000	2022-07-03 09:16:00.000	2022-08-03 09:30:00.000	2022-09-03 09:20:00.000	2022-10-03 09:25:00.000
26	ShiftCC1	2022-01-03 18:10:00.000	2022-02-03 18:15:00.000	2022-03-03 18:05:00.000	2022-04-03 18:10:00.000	2022-05-03 18:13:00.000	2022-06-03 18:14:00.000	2022-07-03 18:16:00.000	2022-08-03 18:30:00.000	2022-09-03 18:20:00.000	2022-10-03 18:25:00.000