we use visual integrator to import sales orders.  I have a customer that sends us a csv file and on that file we have header and detail information on each line.

so i would see something like:

PO#, Vendor#, Shipto, item#, model#, sku#, ship date, qty, price

the data is below, each line has Header and Detail information, but i dont want a sales order for each line, i would like one sales order per PO#, so in this case it would be 2 sales orders, one for PO ABC with 3 items, and another sales order for ZZZ for 1 item? without manipulating the CSV file to much is there a way to do this with little intervention from the user?  i know i could probably have them duplicate the first line of the PO, put an H in the first column and then an I for the other lines for that PO, but seems like that is begging for problems down the line.  any thoughts?

ABC, CPN7, YYZZ, 13120, 1573V, 9921003, 06062015, 1, 3.04

ABC, CPN7, YYZZ, 63120, 6573V, 9926003, 06062015, 1, 5.34

ABC, CPN7, YYZZ, 73120, 7573V, 9927003, 06062015, 1, 13.04

ZZZ, CPN7, YYZZ, 13120, 1573V, 9921003, 06062015, 1, 3.04