Reshuffling of Data Tabulation

[glkhaw2141]

Dear,

Appreciate your assist on the following.
Reshuffle the Data Entry that scatter in Table Tabulation during exporting the Crystal Report to Excel format.

Before:-

[TABLE="class: cms_table_cms_table_cms_table_cms_table, width: 500"]
[TR]
[TD]Item No[/TD]
[TD]PO No[/TD]
[TD]Vendor No[/TD]
[TD][/TD]
[TD]Qty Ordered[/TD]
[TD]Promise Date[/TD]
[TD][/TD]
[TD][/TD]
[TD]Expected Cost[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Vendor Item No[/TD]
[TD][/TD]
[TD]Qty Received[/TD]
[TD]Received date[/TD]
[TD][/TD]
[TD][/TD]
[TD]Actual cost[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Job No[/TD]
[TD][/TD]
[TD]Qty Rejected[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Average Cost[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SUBASY940869302[/TD]
[TD]27484-00[/TD]
[TD]TCE018[/TD]
[TD]500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.60[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]ELDAHO_HJ-LL-016-02-005C[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD]04/12/2014[/TD]
[TD][/TD]
[TD]0.70[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]201500E_A[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD]05/12/2014[/TD]
[TD][/TD]
[TD]0.65[/TD]
[/TR]
[/TABLE]






After:-

[TABLE="class: cms_table_cms_table_cms_table_cms_table, width: 500"]
[TR]
[TD]Item No[/TD]
[TD]PO No[/TD]
[TD]Job No[/TD]
[TD]Qty Ordered[/TD]
[TD]Qty Received[/TD]
[TD]Received Date[/TD]
[TD]Actual Cost[/TD]
[/TR]
[TR]
[TD]SUBASY940869302[/TD]
[TD]27484-00[/TD]
[TD]201500E_A[/TD]
[TD]500[/TD]
[TD]200[/TD]
[TD]05/12/2014[/TD]
[TD]0.700[/TD]
[/TR]
[/TABLE]





Thanks in advance for your kind support.

Regards,
Khaw GL