Could it be as simple as this?

SELECT

s.Space_Number,

MIN(e.First) AS First1,

MIN(e.Last) AS Last1,

MAX(e.First) AS First2,

MAX(e.Last) AS Last2,

MIN(e.CC) AS FirstOfCC,

MIN(e.[Employee Type]) AS [FirstOfEmployee Type],

s.[Space Type]

FROM Spaces s

LEFT JOIN Employee e

ON s.Space_ID = e.Space_Number

GROUP BY s.Space_Number, s.[Space Type];