All,

I have to re arrange a huge data which is in 240*2000. iam giving the present data format below and the expected output format too. please please some body help. sos.

Present form of the data:

ID NUMBER 05-07-2010 06-07-2010 07-07-2010
55827 1 5 1
55832 2 12 0
55813 3 100 0
55826 1 0 5
55828 0 252 0
55840 3 20 0
55829 6 20 5

expected output of the data:

ID NUMBER AMOUNT DATE
55827 1 05-07-2010
55832 2 05-07-2010
55813 3 05-07-2010
55826 1 05-07-2010
55828 0 05-07-2010
55840 3 05-07-2010
55829 6 05-07-2010
55827 5 06-07-2010
55832 12 06-07-2010