If cell is 0, INDEX next row

I'm listing my defined data 'allhazards' (50 rows x 8 columns) and there are 0's in cells where no data is entered.

I'm converting the 50 rows x 8 columns into 400 rows x 1 column using this formula:
=INDEX(allhazards,1+INT((ROW($A1)-1)/COLUMNS(allhazards)),MOD(ROW($A1)-1+COLUMNS(allhazards),COLUMNS(allhazards))+1)

How do I modify it to NOT reference the 0's? I.e. if cell is 0, move to next row, keep doing this until no rows are left

eg. (3 rows x 8 columns)
row1col1 row1col2 row1col3 row1col4 row1col5 row1col6 0 0
row2col1 row2col2 0 0 0 0 0 0
row3col1 0 0 0 0 0 0 0

would turn into this:
row1col1
row1col2
row1col3
row1col5
row1col6
row2col1
row2col2
row3col1

without the cells containing zeroes

Any ideas? Thanks in advance for your help