Cross tab data required

Can't it be done thourgh sql statement?

It can be to some extent. For e.g.

SELECT  [ClientID]
,     SUM( CASE WHEN [Department] = 'Dep1' THEN [MF] ELSE 0 END) [MF]
,       SUM(CASE WHEN [Department] = 'Dep1' THEN [FD] ELSE 0 END) [FD]
,       SUM(CASE WHEN [Department] = 'Dep1' THEN [AUM] ELSE 0 END)[AUM]
,       SUM( CASE WHEN [Department] = 'Dep2' THEN [MF] ELSE 0 END) [MF]
,       SUM(CASE WHEN [Department] = 'Dep2' THEN [FD] ELSE 0 END) [FD]
,       SUM(CASE WHEN [Department] = 'Dep2' THEN [AUM] ELSE 0 END)[AUM]
FROM [ClientMaster]
GROUP BY [ClientID]

But t-sql is not meant to be used for presentation. As @Fatherjack already told you, for that you have to use tools, which will make it pretty simple. Otherwise, you could find yourself in a predicament.

Please guide me with tools that we can use with SSMS 2005 since I have that one!