Hi!

I have the following (column A - column B) on sheet1

Order 1 - Apple
Order 1 - Banana
Order 2 - Toycar
Order 3 - Bag
Order 3 - Shoes
Order 3 - TV

I want to find all occurences of orders on sheet1 and list them on sheet2, resulting in:
Order 1 - Apple - Banana
Order 2 - Toycar
Order 3 - Bag - Shoes - TV

Is anyone able to help me? Thanks for your time.