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
- order no.
- SKU/Item desc
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By matt99b in forum Excel Formulas & Functions
Last Post: 07-10-2008, 12:41 PM
By karl_009 in forum Excel Programming / VBA / Macros
Last Post: 06-30-2008, 06:35 AM
By jumbo5 in forum Excel General
Last Post: 01-27-2008, 04:58 PM
By annepopa in forum Excel General
Last Post: 02-19-2007, 04:53 PM
By Jacquesvs in forum Excel General
Last Post: 01-26-2007, 03:13 AM
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1