Today’s author is Bob Umlas, an Excel MVP since 1994. This tip is a formula which enables you to access a list of values interspersed with zeros or blanks and pick up only the non-zero values in the same sequence they’re listed
Go here to read the rest:
Formula to Access a List of Values Interspersed with Zeros or Blanks