SQL Server 2019

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

CREATE TABLE output_table(
    Date 	             DATE,
    Time 	             TIME,
    UserID 	             INT,
    UserName 	             VARCHAR(20),
    EventSubTypeDescription  VARCHAR(20)
);
INSERT INTO output_table VALUES
('2022-05-09', 	'07:53', 	393, 	'Jennifer', 	'Clock in' ),
('2022-05-09', 	'13:33', 	393, 	'Jennifer', 	'Clock out'),
('2022-05-09', 	'14:06', 	393, 	'Jennifer', 	'Clock in' ),
('2022-05-09', 	'16:57', 	393, 	'Jennifer', 	'Clock out'),
('2022-05-09', 	'07:59', 	401, 	'agency 2', 	'Clock in' ),
('2022-05-09', 	'12:58', 	401, 	'agency 2', 	'Clock out'),
('2022-05-09', 	'13:27', 	401, 	'agency 2', 	'Clock in' ),
('2022-05-09', 	'16:56', 	401, 	'agency 2', 	'Clock out'),
('2022-05-09', 	'07:57', 	422, 	'Tash' 	  ,     'Clock in' ),
('2022-05-09', 	'13:56', 	422, 	'Tash' 	  ,     'Clock out'),
('2022-05-09', 	'07:58', 	432, 	'agency 4', 	'Clock in' ),
('2022-05-09', 	'13:00', 	432, 	'agency 4', 	'Clock out'),
('2022-05-09', 	'13:30', 	432, 	'agency 4', 	'Clock in' ),
('2022-05-09', 	'16:56', 	432, 	'agency 4', 	'Clock out'),
('2022-05-09', 	'07:57', 	434, 	'Jordan'  ,	'Clock in' ),
('2022-05-09', 	'13:32', 	434, 	'Jordan'  ,	'Clock out'),
('2022-05-09', 	'14:03', 	434, 	'Jordan'  ,	'Clock in' ),
('2022-05-09', 	'16:59', 	434, 	'Jordan'  ,	'Clock out'),
('2022-05-09', 	'07:59', 	438, 	'Adam' 	  ,     'Clock in' ),
('2022-05-09', 	'12:59', 	438, 	'Adam'    ,     'Clock out'),
('2022-05-09', 	'13:29', 	438, 	'Adam' 	  ,     'Clock in' ),
('2022-05-09', 	'16:56', 	438, 	'Adam' 	  ,     'Clock out');

22 rows affected

Date	UserID	Username	Clock_in	Clock_out	Clock_in_2	Clock_out_2
2022-05-09	393	Jennifer	07:53:00.0000000	13:33:00.0000000	14:06:00.0000000	16:57:00.0000000
2022-05-09	401	agency 2	07:59:00.0000000	12:58:00.0000000	13:27:00.0000000	16:56:00.0000000
2022-05-09	422	Tash	07:57:00.0000000	13:56:00.0000000	null	null
2022-05-09	432	agency 4	07:58:00.0000000	13:00:00.0000000	13:30:00.0000000	16:56:00.0000000
2022-05-09	434	Jordan	07:57:00.0000000	13:32:00.0000000	14:03:00.0000000	16:59:00.0000000
2022-05-09	438	Adam	07:59:00.0000000	12:59:00.0000000	13:29:00.0000000	16:56:00.0000000

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