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
Bookmarks