attached is a sample excel file. it contains 2worksheets. one is the original I'm working on. one is the after layout which i choose to achieve.
my data consists of
- date
- order no.
- SKU/Item desc
- qty
one order can include any 3 of the Items.
As seen in the "before" worksheet. there are duplicates of order no.
I would wish to consolidate the item orders so as to remove duplicates of order no.
Bookmarks