SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.YourTable (Name varchar(10), --Using a name that doesn't require delimit identification
                            Status varchar(7), --Using a name that doesn't require delimit identification
                            Days int);
INSERT INTO dbo.YourTable(Name, Status, Days)
VALUES('Mal','Present',30),
      ('Jess','Present',20),
      ('Rick','Absent',30),
      ('Jerry','Absent',10);
4 rows affected

WITH RNs AS(
    SELECT Name,
           Status,
           Days,
           ROW_NUMBER() OVER (PARTITION BY Status ORDER BY Days DESC) AS RN
    FROM dbo.YourTable)
SELECT P.Name AS PresentName,
       P.Days AS PresentDays,
       A.Name AS AbsentName,
       A.Days AS AbsentDays
FROM (SELECT R.Name,
             R.Days,
             R.Status,
             R.RN
      FROM RNs R
      WHERE R.Status = 'Present') P
    FULL OUTER JOIN (SELECT R.Name,
                            R.Days,
                            R.Status,
                            R.RN
                     FROM RNs R
                     WHERE R.Status = 'Absent') A ON P.RN = A.RN;


PresentName
PresentDays
AbsentName
AbsentDays


Mal
30
Rick
30

Jess
20
Jerry
10


DROP TABLE dbo.YourTable;