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
Bookmarks