Correcting an excel sheet after exporting from crystal report

[excelnewbie34]

Exceln.jpg
Please see the attached image.
Exceln.xls

Thanks for the help.

[Rick Rothstein]

Please see the attached image.
Exceln.xls

Some questions on the worksheet you posted...

1) You have a section labeled "So it would look like this at the end"... does that mean you do not want the split apart data fixed on the worksheet, but rather, you only want the data you showed in this labeled section to be outputted by itself?

2) What about the data in Row 1 thru 10... is that supposed to be copied, as is, first, and then the output data format you showed in the labeled section would follow it?

3) Does the data you want outputted always start on Row 11?

4) It looks like all the data you want listed in columns is shown in the raw data with the header text in the cell before it (for example, Column E has "Order no:" in it and Column F has the actual order number)... all but the Product Name (Column M)... the cell to the left of it (Column L) does not show the words "Product Name:", rather, it shows the date that goes in the "Expect:Delivery" column... is that correct or did you post a bad sample with the "Product Name:" data column missing?