How to look for duplicates in first column, then copy / paste contents of second column?

Hi,

Very new VBA user here, but ran across an Excel problem that is seemingly unsolvable without VBA.

I have item #'s in column "A," (let's say, item 10, 11, 12, 13, 14...) and product #'s in column "B" (let's say product #'s AA, AB, AC, AD). Some items have more than one product associated.

How can I put all the product #'s for each item onto one row? See attachment for a small sample of the data.

Thanks for any help!!

Here is how I tried to write the code:

Please Login or Register  to view this content.

please attache any workbook with dummy data and show us how output should looks like

Hello speedyhub,

Finally I've created code for You - follow below points
1. sort your source array regarding ID
2. use provided procedure (copy it into module or to source code of your sheet)
3. use autofilter for get expected result

Please Login or Register  to view this content.

If you will need any more help do not hasitate to post it.