Hi

I have a CSV sheet with a number of rows on of customer order data that I need to merge into a Word document

However, where the CSV data is downloaded from our system if a customer orders multiple products (lets say two different products for now) it gives me one line of data for their first product order, which would be: their name, order number, address details, product name - and then it gives me the same data again with different product name for the second item they ordered.

This means that I end up with a line of data per item ordered and not per order made (if that makes sense).

I need to find a way of when I import my CSV file into Excel of looking at the data and merging the same fields of data into one and then merging products ordered into one field, so i would get the following,

1) Order No 1 : Address : Name : Item1, Item 2

instead of

1) Order No 1 : Address : Name : Item1
2) Order No 1 : Address : Name : Item2

This is so that when i merge into Word, I get one order / receipt sheet per customer if they order multiple items as opposed to getting multiple order sheets per item they ordered as I get now!

Hope this makes sense and help is greatly appreciated!

Cheers

Jon