Find all Orders in column, create a new list on different sheet

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.

Originally Posted by banaanas

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.

Hope your right attention
See File:

Please Login or Register  to view this content.

banaanas

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Yeah Will do! One more question though.

Is it possible to modify your code to get the different products on the same row but in different columns instead of only in column b?
Like:

Column A Column B Column C
Order 1 Toycar Banana

Thanks, yet again very much!

If you upload a workbook with your desired result, it will help understanding what you are trying to do.

Okay, here:

From sheet 1 to sheet 2. The column captions are not necessary to get transferred, I only put them there to clear things up. The macro don't need to write them, only the data

This should do

Please Login or Register  to view this content.

Yes, it works like a charm. Greatly appreciated my man!