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:-

Item No	PO No	Vendor No		Qty Ordered	Promise Date			Expected Cost
		Vendor Item No		Qty Received	Received date			Actual cost
		Job No		Qty Rejected				Average Cost
SUBASY940869302	27484-00	TCE018	500					0.60
		ELDAHO_HJ-LL-016-02-005C	200			04/12/2014		0.70
		201500E_A	50			05/12/2014		0.65

After:-

Item No	PO No	Job No	Qty Ordered	Qty Received	Received Date	Actual Cost
SUBASY940869302	27484-00	201500E_A	500	200	05/12/2014	0.700

Thanks in advance for your kind support.

Regards,
Khaw GL