Help with Concatenate Data

Hello All

I have a problem I hope you all can help me with.

I have data in column's A & B. I am trying to combine data from Column B based on data in Column A to Column C. I was trying do something similar to SUMIF, to concatenate but it doesn't work.

I am trying to achieve the following in Column C:
Col. A Col. B Col. C
1 dog dog, chicken
2 cat cat, pig, rat
1 chicken dog, chicken
7 sheep sheep
4 dog dog, chicken
5 cow cow
2 pig cat, pig, rat
5 cow cow
2 rat cat, pig, rat

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will be closed, you should continue in your other thread.