I tried TonyJ's suggestion since it was easy enough for me.

select

FirstName

, lastName

, max(Case when ContractType = 'Fixed' then ContractType else '0' end)

+ ',' + max(Case when ContractType...