SQL Server 2017

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

CREATE TABLE elbat
             (itemid integer,
              type varchar(4),
              date datetime);
INSERT INTO elbat
            (itemid,
             type,
             date)
            VALUES (441455, 'I-UN', '2019-03-24 8:00'),
                   (441455, 'W-WS', '2019-03-24 8:09'),
                   (441455, 'I-UN', '2019-03-24 9:47'),
                   (441455, 'W-WS', '2019-03-24 9:51'),
                   (441455, 'I-UN', '2019-03-24 12:20'),
                   (441455, 'W-WS', '2019-03-24 12:26'),
                   (441455, 'I-UN', '2019-03-24 15:50'),
                   (441455, 'W-WS', '2019-03-24 15:53');
8 rows affected

SELECT t1.itemid [ItemID],
       t1.date [I-UN Date],
       t2.date [W-WS Date]
       FROM (SELECT itemid,
                    date,
                    row_number() OVER (ORDER BY date) r#
                    FROM elbat
                    WHERE type = 'I-UN') t1
            FULL JOIN (SELECT itemid,
                              date,
                              row_number() OVER (ORDER BY date) r#
                              FROM elbat
                              WHERE type = 'W-WS') t2
                      ON t1.itemid = t2.itemid
                         AND t1.r# = t2.r#;


ItemID
I-UN Date
W-WS Date


441455
24/03/2019 08:00:00
24/03/2019 08:09:00

441455
24/03/2019 09:47:00
24/03/2019 09:51:00

441455
24/03/2019 12:20:00
24/03/2019 12:26:00

441455
24/03/2019 15:50:00
24/03/2019 15:53:00

ItemID	I-UN Date	W-WS Date
441455	24/03/2019 08:00:00	24/03/2019 08:09:00
441455	24/03/2019 09:47:00	24/03/2019 09:51:00
441455	24/03/2019 12:20:00	24/03/2019 12:26:00
441455	24/03/2019 15:50:00	24/03/2019 15:53:00