Hello Maureeze,

Suppose your data is in Sheet1, A1:C4.

Then enter into Sheet2, A1:E4:
Date 39397
Occurrence 0
1st =B2+MATCH(Sheet2!$B$1,OFFSET(Sheet1!$A$1:$A$1000,B 2,0),)
=INDEX(Sheet1!$1:$65536,Sheet2!$B3,1) =INDEX(Sheet1!$1:$65536,Sheet2!
$B3,2) =INDEX(Sheet1!$1:$65536,Sheet2!$B3,3)
2nd =B3+MATCH(Sheet2!$B$1,OFFSET(Sheet1!$A$1:$A$1000,B 3,0),)
=INDEX(Sheet1!$1:$65536,Sheet2!$B4,1) =INDEX(Sheet1!$1:$65536,Sheet2!
$B4,2) =INDEX(Sheet1!$1:$65536,Sheet2!$B4,3)

[39397 is 11-Nov-2007]
Copy B4:E4 down as far as necessary.

Regards,
Bernd