omitting blank cells

I have a table of data whose shape and number can vary, ie sometimes we will have 10 data points in groups of 2. Sometimes it is 49 data in groups of 7. Other times it can be 21 data points in groups of 3. However, there will never be more than 10 groups and 10 data points per group (a total of 100 data points in 10 groups). I would like to create a function that searches the table and returns the values of the cells but omits the blank cells. I intend to return the values in a single column. Is this doable? Thanks.