If cell is the same, equal adjacent value and sort alphabetically in one cell

Hi All

I am not sure is this can be done but I am looking for a formula that if the cell in column A is duplicated then take the value in column B and add together in one cell alphabetically. Preferably separated by a comma

I have attached an example

Cell C2 formula , Drag down

Formula:

Please Login or Register  to view this content.

Thank you for your response, however the formula is returning the below result

#VALUE!
#VALUE!
#VALUE!
Orange,Promo 2
Orange,Promo 2
#VALUE!
#VALUE!
#VALUE!

How about

Formula:

Please Login or Register  to view this content.

Hi Boudene , There is no problem with the formula, please see this attachment

Power Query:

Please Login or Register  to view this content.