vba to concatenate data and return multiples values from unique list

[JEAN1972]

Hi all

I have a database of 75000 rows actually and it continues to expand daily.

Some products have different statistics code and description.

On the right are unique items with compilation of different statistics code and description in one cell as per database .

The item no is unique that needs to taken in account for unique list

looking a vba code to speed up process in one cell as per attached



Thanks if anyone can assist