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