Filter function to return in columns not rows

I want to return the results from a filter function formula into ongoing columns rather than down rows - this is because I have a large list of over a 2000 rows of data that I want to look them up in...