I would like to convert the columns in to rows and rows in to columns. Not all the properities but only output wise(display only).
There is a chance of having more columns with data.
My table is as follows:
ACID DOT TXNTYPE SUM_OF_TRANS_AMOUNT
101 2014-05-08 CD 750000
102 2014-05-08 CW 900000
ACID:- ACCOUNT ID; DOT:- DATE OF TRANSACTION; TXNTYPE:- TRANSACTION TYPE; TOTAL OF THE BALANCE IN THE ACCOUNT
ACID 101 ...
Go to the complete details ...