Views fields as Columns in table
You could try to use Views aggregation.


Define the relationships of the fields.
Under Advanced > Other enable aggregation
Add fields of the animal nodes and define the grouping as "count" in the field's aggregation settings.
Define no results bahaviour as "No" and rewrite the result as "Yes". Define 0 as "no result". All in the field settings.


Hope that helps!

cheers,
j