I basically have an order form split into 2 different areas.
The top, which customer data like billing address and so on and thebottom which has the order details such as the item, quantity ordered and price.

I need to take this form and manipulate the data so it can be imported as a flat file. In order to do this I need to create a new sheet which takes the customer info and puts it in the same row as each different item being ordered.
example:
john doe, 3, red hat, 9.99
john doe, 6, blue hat, 9.99
john doe, 12, red slippers, 12.99

so "john doe" would be in cell A1 and then all the products would be in cells:
A10, B10, C10
A15, B15, C15
A78, B78, C78

There are products inbetween the ones ordered, but I only need rows where the Quantity (all rows below A10-A350) where the cell is greater than or equal to 1.

Thanks
JZ