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 another table and return all the possible values for one code.  i.e. I have hierachical data that is coded and I want to see the unique codes for a level of code up.  My formula is currently: 

=FILTER('ACNY 2024'!L2:L15979,'ACNY 2024'!I2:I15979='Parish make up'!AX2)

Or can I do an xlookup that returns multiple answers but the number of answers will vary between 1 and 13?  Many thanks