I have a very large table representing operations at different times, scattered with numbers but populated mostly with blanks.
It looks something like this,
A B C
1
1 1
1
2
1
1
4
Total.................
I want to do some statistical analysis on the time between operations so I am hoping to produce a second table below the first that lists the number of blanks in each gap, sequentially for each column.
Something like this,
A B C
Gap 1 3 2 2
Gap 2 1 2 5
Gap 3 3
I know what the maximum number of gaps is, but the number of gaps in each column varies.
Can anyone think of a way to achieve this?
Bookmarks