Please, read my comment to the question.
SELECT BookTitle, Library_Department_ID, SectorID, [Reference], [Issue]
FROM (
SELECT BookTitle, Library_Department_ID, SectorID, NoofCopies, CASE WHEN [Status] = 1 THEN 'Reference' ELSE 'Issue' END
FROM tbl_bookmst
WHERE Status= 1
) AS DT
PIVOT(SUM(NoofCopies) FOR [Status] IN([Reference], [Issue])) AS PT