ROUGH and lengthy query if you have more records ..

using some other method i think you can make it short

SELECT A.P,A.AGENCY1,A.AMOUNT1,B.AGENCY2,B.AMOUNT2 FROM

(select PROJECTID AS P, AGENCY AS AGENCY1,AMOUNT AS AMOUNT1

FROM [FundingSources]

WHERE AGENCY='XYZ') A

JOIN

(select PROJECTID AS P,AGENCY AS AGENCY2,AMOUNT AS AMOUNT2

FROM [FundingSources]

WHERE AGENCY='ABC')B ON(A.P=B.P)