Postgres 12

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

CREATE TABLE t (
  Timestamp   VARCHAR(20),
  Event_Name  VARCHAR(20)
);
INSERT INTO t
VALUES('10:47:00','RESUME'),
      ('10:37:52','SUSPEND'),
      ('10:26:20','RESUME'),
      ('09:48:27','SUSPEND'),
      ('09:39:13','RESUME'),
      ('09:15:38','SUSPEND'),
      ('09:11:42','RESUME')
7 rows affected

WITH t AS
( 
  SELECT CASE
           WHEN Event_Name = 'SUSPEND' THEN
            Timestamp
         END AS Suspend,
         CASE
           WHEN Event_Name = 'RESUME' THEN
            Timestamp
         END AS Resume,
         SUM(CASE
               WHEN Event_Name = 'SUSPEND' THEN
                1
               ELSE
                0
             END) OVER(PARTITION BY Event_Name ORDER BY Timestamp) AS rn_suspend,
         SUM(CASE
               WHEN Event_Name = 'RESUME' THEN
                1
               ELSE
                0
             END) OVER(PARTITION BY Event_Name ORDER BY Timestamp) AS rn_resume  
    FROM t
)
SELECT s.suspend, r.resume
  FROM (SELECT * FROM t WHERE resume IS NOT NULL) AS r
  FULL JOIN (SELECT * FROM t WHERE suspend IS NOT NULL) AS s
    ON s.rn_suspend = r.rn_resume
 ORDER BY r.rn_resume DESC, s.rn_suspend DESC


suspend
resume


null
10:47:00

10:37:52
10:26:20

09:48:27
09:39:13

09:15:38
09:11:42

suspend	resume
null	10:47:00
10:37:52	10:26:20
09:48:27	09:39:13
09:15:38	09:11:42