SELECT
a.Project_Id,
a.[Status],
b.[Status],
a.[ProcessName]
FROM
YourTable a
LEFT JOIN YourTable b ON
a.Project_id = b.Project_id
AND a.ProcessName = b.ProcessName
AND b.[Status] = 'END'
WHERE
a.[Status] = 'START'
ORDER BY
a.Project_id;
SELECT
Project_Id,
MAX(CASE WHEN Status = 'START' THEN 'START' END) AS Status1,
MAX(CASE WHEN Status = 'END' THEN 'END' END) AS Status2,
MAX(CASE WHEN Status = 'START' THEN ProcessName END) AS ProcessName
FROM table_name
WHERE
Status IN ('START', 'END')
GROUP BY Project_Id
ORDER BY Project_Id;