Merge Multiple column in next sheet

I have worksheet having co. name wise data in to 2 columns Advise no and Amount, i want to merge all co.name wise data in to next sheet. attached file for your ref. ( column and data r not fixed )

Pls help.


https://dl.dropbox.com/u/66400357/Merge%20Column.xlsx

no solution ??