You'll get tested answers if you provide some consumable data... How about...
SELECT ID, StartDate, EndDate, ContractValue, Manager
FROM
(VALUES (1,'2019-11-01','2020-06-30',45000,'Stephen Smith'),
(2,'2019-12-01','2020-07-30',75000,'Carol Kenin'),
(3,'2020-01-15','2020-08-30',25000,'John Gnan'),
(4,'2020-02-01','2020-09-30',40000,'Jacob Joklin')) z(ID, StartDate, EndDate, ContractValue, Manager);
Works if you add a matrix to the canvas and create a Column Group on ContractID, and then add the other columns and put then inside the group.