Very quick and dirty :
Select tbl_BankBook.Amount as Expenditure , 0 as Income from tbl_BankBook where tbl_BankBook.Status = 'Expenditure'
UNION
Select 0 as Expenditure , tbl_BankBook.Amount as Income from tbl_BankBook where tbl_BankBook.Status = 'Income'
Check up on PIVOT queries
Cheers