Split a column interspersed with zeros into separate columns in Excel, while breaking at zeros

I am looking to split a column array interspersed with zeros into separate columns in Excel while breaking at the zeros in the column and ignoring the zeros. For example, if I have an array {1,2,3,0,4,5,0,0,6,7,0}, Excel should retu three arrays - array 1 should be {1,2,3}, array 2 should be {4,5}, and array 3 should {6,7}. How can I do this in excel?

Recent Questions...