What you might need to do is split your data into two different sheets. The first sheet will be the information for each individual order, the second sheet will be the product data per order. Then, you'll need to nest two different Data Loops so that you will loop through once for each order and then, within that loop, you'll loop once per product for the order. Within the product loop, you'll need to do some sort of conditional check to see if the product record is supposed to be for the current order record.
I'd be able to give better suggestions based upon your XLS but I'm unable to open the sheet.
