If cell is 0, reference next row of cells

I'm listing 50 rows x 8 columns of cells (defined 'allhazards')

However each cell in myhazards is referencing other sheets and contain 0's where there is no text to be referenced.

When I list myhazards in a single column using this formula:

=INDEX(allhazards,1+INT((ROW($A1)-1)/COLUMNS(allhazards)),MOD(ROW($A1)-1+COLUMNS(allhazards),COLUMNS(allhazards))+1)
(then drag down the column to get all of the cells from 'allhazards')

How do I implement this:

if cell in 'allhazards' is 0, do not reference this, move to next row
...then reference next row's columns until cell is 0, then move to next row
...keep doing this until there are no rows left to be referenced

eg. if 'allhazards' contained these cells (eg. 2 rows x 8 columns):
hello how are 0 0 0 0 0
good 0 0 0 0 0 0 0

It should produce this:
hello
how
are
good

but not this:
hello
how
are
0
0
0
0
0
good
0
0
0
0
0
0
0