I have a list that includes many-to-one relationships. I need to turn this
into a one-to-one relationship by concatenating the values of each of the
multiples. For example:

ID Name CountID
07 cat 3
07 dog 3
07 pig 3
12 fish 1
19 apple 2
19 grape 2

I can put my formula to the right, so I'm hoping toe end up with:

ID Name Count Concatenated
07 cat 3 cat, dog, pig
07 dog 3
07 pig 3
12 fish 1 fish
19 apple 2 apple, grape
19 grape 2

I can use a match statement against the ID to only populate rows with a new
ID (that's easy) but I haven't figured out a way to concatentate "the cell to
the left, and N cells down" based on the count column.

Any ideas?

Thanks!
Keith