I think you'll need to import the records into a tempory table and then use a script to loop through the records. It looks to me like the order id is on one line and then subsequent records contain the individual items ordered so this would be data to move into two tables, one where you have a record for each order and one where you have a related record for each item purchased.
How would i be able to import the Data into different Tables, Order Line Items into one Table and the Orders into another table?
Thanks for your help!
You could import directly into Orders to populate Orders with new Orders records, a validation rule can filter out the rows where Order ID is blank.
But you won't be able to simply import into Order Line Items, you'll need a script to capture the Order ID values and enter them where needed into the individual records. A temp table is probably simpler and safer but I won't say it wouldn't be impossible to import into order line items and then use a script to fill in the missing Order ID values.
I will definitely try the Temp Table.
Thanks for the info.