Slicing Array Based On Conditions

Given an input array (result of a calculation )

Input Array = [3 4 9 1 0 5 7 2 0 6 10 8 ]

Depending on the number and location of the zeroes, I would like to create a sorted array whose

- number of rows is determined by the number of zeroes in the input matrix (i.e number of zeroes - 1)

- number of columns determined by the the size of one maximum number of elements in one of the smaller arrays. The remaining entries on the other shorter rows will be made zero.

For the above example sorted array becomes a 3X4 array

1 3 4 9
2 5 7 0
6 8 10 0

Example 2

Input Array = [9 4 5 0 1 7 6 2 10 3 8]
Sorted Array is a 2X7 Array
4 5 9
1 2 3 6 7 8 10

I would like to generate this array in VBA (rather than writing/reading in a worksheet) as it will save a lot of calculation time.