I am trying to combine values from multiple cells based on a common variable.
I have multiple collie references that are shipped together, and I wish to list these bases on the shipping number.

My data in the example file is like this:
Column A is the shipping number.
Column B is a reference.

In column C I would like to “collect” the reference values (column B) from all the rows with the same shipping number (column A).

It is important that the values are “collected” into one cell and not multiple.
It is also important that there can be like 20 or 30 rows with the same shipping number, so the function should not be limited to an amount of rows.

In my example I only “collect” the values in the first row of the shipping number – that is nice to have, but I can fix this in other ways.

I would really appreciate some help, I have been searching this for hours without finding a proper solution :-(

Attached example
Eksempel.xlsx