SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab1
    ([PersonID] int, [Event] varchar(7), [Date] date, [Name] varchar(5), [Status] varchar(8))
;
    
INSERT INTO tab1
    ([PersonID], [Event], [Date], [Name], [Status])
VALUES
    (1, 'Event A', '1900-12-31', 'John', 'Pending'),
    (1, 'Event A', '1900-01-02', 'John', 'Pending'),
    (2, 'Event B', '1900-12-31', 'Sarah', 'Pending'),
    (2, 'Event B', '1901-01-01', 'Sarah', 'Complete')
;
4 rows affected

SELECT [Date] , DATEPART(DW, [Date]) FROM tab1


Date
(No column name)


1900-12-31
2

1900-01-02
3

1900-12-31
2

1901-01-01
3


SELECT
[PersonID],[Name], [Event],
MAX(CASE WHEN DATEPART(DW,[Date]) = 2 then [Status] ELSe '' ENd) [Monday],
MAX(CASE WHEN DATEPART(DW,[Date]) = 3 then [Status] ELSE '' ENd) [Tuesday],
MAX(CASE WHEN DATEPART(DW,[Date]) = 4 then [Status] ELSE '' ENd) [Wednesday],
MAX(CASE WHEN DATEPART(DW,[Date]) = 5 then [Status] ELSE '' ENd) [Thursday],
MAX(CASE WHEN DATEPART(DW,[Date]) = 6 then [Status] ELSE '' ENd) [Friday]
FROM tab1
GROUP BY
[PersonID],[Name], [Event]


PersonID
Name
Event
Monday
Tuesday
Wednesday
Thursday
Friday


1
John
Event A
Pending
Pending




2
Sarah
Event B
Pending
Complete