Try this :

select distinct [name]

,animal = isnull(case when class = 'animal' then 'X' end,0)

,cats = isnull(case when subclass = 'cat' then [name] end,0)

,mouse = isnull(case when...