No EmployeeId? Why? You might have two employees with the same name..

SELECT DISTINCT

EmployeeId ,

Date ,

Employee ,

STUFF(( SELECT ' and ' + t2.Summary AS [text()]

FROM tblEmployee t2

WHERE t2.EmployeeId = t1.EmployeeId

FOR

XML PATH('')

), 1, 5, '') AS Summary

FROM tblEmployee t1