Sorting exported data from crystal report

[excelnewbie34]

Hi,

After I export data from crystal report it appears to have lost its original position and some data go under different columns. I have no access to editing the original template.
I have columns starting from A to AK on the sheet. An example is given below. I use Excel 2007. The information statistics is over a month and analysis is difficult due to the export issue.

[TABLE="width: 503"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 439"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]1600123[/TD]
[TD]Name 1[/TD]
[TD]BUY DATE[/TD]
[TD]01/01/2011[/TD]
[/TR]
[TR]
[TD]1532345[/TD]
[TD]Name 2[/TD]
[TD]BUY DATE[/TD]
[TD]02/01/2012[/TD]
[/TR]
[TR]
[TD]Mango 3[/TD]
[TD]Apple[/TD]
[TD]Mango 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2134546[/TD]
[TD]Name 3[/TD]
[TD]BUY DATE[/TD]
[TD]03/01/2011[/TD]
[/TR]
[TR]
[TD]Mango 3[/TD]
[TD]Apple2[/TD]
[TD]Mango 4[/TD]
[TD]Mango 3[/TD]
[/TR]
[TR]
[TD]123487[/TD]
[TD]Name4[/TD]
[TD]BUY DATE[/TD]
[TD]03/02/2011[/TD]
[/TR]
[TR]
[TD]Mango 3[/TD]
[TD]Apple3[/TD]
[TD]Mango 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]345612[/TD]
[TD]Name5[/TD]
[TD]BUY DATE[/TD]
[TD]03/03/2011[/TD]
[/TR]
[TR]
[TD]Mango 3[/TD]
[TD]Apple4[/TD]
[TD]Mango 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]120978[/TD]
[TD]Name6[/TD]
[TD]BUY DATE[/TD]
[TD]02/03/2011[/TD]
[/TR]
[TR]
[TD]Mango 3[/TD]
[TD]Apple5[/TD]
[TD]Mango 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34258[/TD]
[TD]Name 7[/TD]
[TD]BUY DATE[/TD]
[TD]01/03/2011[/TD]
[/TR]
[TR]
[TD]Mango 3[/TD]
[TD]Apple 6[/TD]
[TD]Mango 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]65783[/TD]
[TD]Name 8[/TD]
[TD]BUY DATE[/TD]
[TD]04/01/2011[/TD]
[/TR]
[TR]
[TD]34298[/TD]
[TD]Name 9[/TD]
[TD]BUY DATE[/TD]
[TD]01/04/2011[/TD]
[/TR]
[TR]
[TD]Mango 3[/TD]
[TD]Apple 7[/TD]
[TD]Mango 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23490[/TD]
[TD]name 10[/TD]
[TD]BUY DATE[/TD]
[TD]02/04/2011[/TD]
[/TR]
[TR]
[TD]Mango 3[/TD]
[TD]Apple 8[/TD]
[TD]Mango 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]342[/TD]
[TD]Name 11[/TD]
[TD]BUY DATE[/TD]
[TD]01/06/2011[/TD]
[/TR]
[TR]
[TD]45623[/TD]
[TD]Name 12[/TD]
[TD]BUY DATE[/TD]
[TD]01/03/2011[/TD]
[/TR]
[TR]
[TD]45672[/TD]
[TD]Name 13[/TD]
[TD]BUY DATE[/TD]
[TD]06/01/2011[/TD]
[/TR]
[TR]
[TD]3450978[/TD]
[TD]Name 14[/TD]
[TD]BUY DATE[/TD]
[TD]07/06/2011[/TD]
[/TR]
[TR]
[TD]3459067[/TD]
[TD]Name 15[/TD]
[TD]BUY DATE[/TD]
[TD]04/02/2011


[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Each of these column has other data coming in between.
1st column should only contain numbers.
Second column should only contain Names.
3rd column(Buy date) is a heading of the 4th column. It also has another column data (mango 4) coming in between.
Ideally the data in the 3rd row should come after the 4th column in the second row and likewise.
Some rows do not have that information(mango 3, apple 4 and mango 4) and it is absent as you can see in the last 4 rows which fine.
Is there any way to clean up this and move all the rows coloured in green to come directly right of the data above it?
Like this.

[TABLE="width: 695"]
<colgroup><col><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD]1532345[/TD]
[TD]Name 2[/TD]
[TD]BUY DATE[/TD]
[TD]02/01/2012[/TD]
[TD]Mango 3[/TD]
[TD]Apple[/TD]
[TD]Mango 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2134546[/TD]
[TD]Name 3[/TD]
[TD]BUY DATE[/TD]
[TD]03/01/2011[/TD]
[TD]Mango 3[/TD]
[TD]Apple2[/TD]
[TD]Mango 4[/TD]
[TD]Mango 3[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance.

 

[excelnewbie34]

Sorry to bump this, need some help with this.
thanks