Yuvraj Powar's approach is nice an simple (but probably left out a couple of keywords to save time):

Select Account,

Case when Account = 'Cr' Then Amount End AS...

I tried to recreate this, but couldn't figure out exactly what the structure was of the other tables involved (e.g. Users and UserRoles). Can you add the CREATE TABLE scripts...