Assume that the source data posted is within A1:B11
In C1: =COUNTIF($A$1:A1,"<")
In D1: =COUNTIF($C$1:C1,C1)
In E1, array-entered (press CTRL+SHIFT+ENTER to confirm the formula):
=IF(D1=1,INDEX(B$1:B$11,MAX(IF(C$1:C$11=C1,ROW(C$1 :C$11)))),"")
Copy C1:E1 down to E11. This "pulls" up col B's data (End) and aligns it
exactly as sought with col A's data (Begin) in col E.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
wrote in message
...
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