advanced transpose

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.