Merge row data into one column base on one column unique value

[wpm7113]

Hi There,

I forgot what formula that I can use to merge the one data column from a unique column data

attached is the sample and the results that I want.

Kindly advice

[Pepe Le Mokko]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

[wpm7113]

Thanks Pepe, I 'm using office 2019

[Pepe Le Mokko]

Thank you
Please update your profile accordingly, otherwise the question might be asked with each new thread/post

[wpm7113]

Thank you and just updated

[JeteMc]

Try pasting the following formula into cell C2 and dragging down: =IF(A2=A1,C1&", "&B2,B2)
Let us know if you have any questions.