Using Excel 2007
I have a sheet tab (sheet1) that has a list of product IDs in column A and relative codes in column B. There can be duplicate Product IDs in sheet1.
10.JPG
How can I set up some formulas and break out the table above to look like the table below?
12.JPG
If this cannot be done, can someone show me how to break out the data like the table below?
13.JPG
Your help is greatly appreciated.
Karen
Bookmarks