Rows and columns in report

Hello,

I linked crystal reports to Ms-Excel and later

I need to prepare column and row type report .Please suggest how to do this ,

and also can we do some coding or use SQL in Crystal report pls provide that Attachment 30651