Return non-blank cells in an array to a single column

[LindaLinda]

I have a data table (event calendar) that gives 5 cells to every date of the year. I would like to return all events that happen in a month to a single column (there will never be more than 10 items in a month). The filter formula won't pull from the array I have. =FILTER('2024'!$B$2:$AF$6,'2024'!$B$2:$AF$6<>"") when I select more than one column or row to pull from. Is there any way to pull all the non-blank information into a single column for a given month?

 

[SunnyAlv]

how about Tocol function ? like this

=TOCOL('2024'!$B$2:$AF$6,3)

 

[LindaLinda]

Awesome! I'd never seen a TOCOL before. Very cool

 

[Peter_SSs]

Awesome! I'd never seen a TOCOL before. Very cool

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.