Hi there hoping someone can help.
My documents looks something like this.

Begin End C this formula will be put in c1
1 1 If(a11,b1<"",b1 else go down the
column until you find a number and put it in C1 so that it
2 ***I want to be able to but begin
and end time on the same line so I can manipulate the data later.
3
4 2
5 1
6
7 3
8 2
9
10
11 4

Hope this is clear it would need to look like this
Begin End C
1 1 2
2
3
4 2
5 1 3
6
7 3
8 2 4
9
10
11 4


Thank you for reading this....
CD