I'm using google docs and a mac so I can't use macros and am pretty limited using autofilter.

I have one doc with all of my data which I need "hidden":

Column Header 1 Column Header 2 Column Header 3
Horse a z
Horse b y
Cow c x
Cow d w
Pig e v
Horse f u
Pig g t

And I need a formula so that on another tab I can pull in all data for one item under Column Header 1, with all corresponding column data:

Column Header 1 Column Header 2 Column Header 3
Horse a z
Horse b y
Horse f u