SELECT
Salesman
,PayMode
,SUM(CASE WHEN PayMode = 'Cash' THEN Collection ELSE 0 END) AS Cash
,SUM(CASE WHEN PayMode = 'cheque' THEN Collection ELSE 0 END) AS cheque
FROM Prospect_Detail
WHERE (Purpose = 'Collections' AND PayMode IN('Cash','cheque'))
GROUP BY Salesman,PayMode;