Excel help.

[Typhoon]

Basically, I work for an eCommerce company.

We use magento and this is how our orders come out;

Now, we had a slight issue where if they ordered two products (FRBRED + FRPIL), it wasn't merging them together on the download.

So now, their order number is 12345 (example) and they have two seperate orders under the same order ID, one for FRBED and one for FRPIL.

What is the best way to merge them together?

I can't remove duplicates because theyre sharing the same order ID.

Stumped!

 

[Typhoon]

Sorted it now - conditional formatting by OrderID, sorting by OrderID value and now just going to manually merge and delete duplicate.

Cheers!

 

[Ex-User (19928)]

Conditional formatting isn't a good way to indicate things.
You could use the output from whatever you use and get a unique list of order numbers, then concatenate the fields that aren't identical. EZ.

 

[iain187]

There's a subtotal feature which would probably group the 2 identical order numbers and display the items