I have attached an example of what I am after.
I have two columns of numbers, column A is order numbers and column B is the retail code.
I would like to have a list of Order numbers, that only has the order number listed once and then going across the page I would have the retails codes that pertain to the order number.
Would I be best using a formula or could I some how use a pivot table for this?
Any help will be greatly appreciated!