Merge two duplicate address lines but keep other details - Online order processing.

[JumpInTheFire83]

Good morning,

I have a complicated problem I need to resolve in terms of online order processing. Please see the below image;

As you can see from the above sheet we have orders and each line contains 1 item. However, you can see that lines 3004 & 3005 are the same order, but the customer has ordered two different products (same for lines 3006 & 3007).

Is there anyway I can combine two lines that are the same order, while still keeping all relevant information such as quanity and product code (columns I & J) for the whole order.

Any help on this is greatly appreciated.

Thanks

 

[Domski]

So basically if the order number is the same you want to move all the order detail onto one line?

Dom

 

[JumpInTheFire83]

So basically if the order number is the same you want to move all the order detail onto one line?

Dom

To sum it up quickly, yes that is what I am trying to achieve.

 

[Domski]

Can I change the column order as part of the code? It would be easiest if Quantity, Product Code and Item Name were together.

Dom