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:

Sub FindDuplicates()
Dim RC As Integer
Dim i As Integer, j As Integer

'count the rows in the list
RC = Range("A1").CurrentRegion.Rows.Count

'loop through all the tags to find duplicates
For i = 2 To RC
    For j = 2 To RC
        
        If Cells(i, 1) = Cells(j, 2) Then Cells(j, 4).Select
        Selection.Cut
        Cells(i, 5).PasteSpecial Paste:=x1PasteValues
        End If
    Next i
        Next j