Hi
I have data in the following form, with each ID having numerous events
against it:
ID End Date Event
1 1/1/2004 A
1 1/2/2004 B
1 1/3/2004 C
2 1/4/2004 X
2 1/5/2004 Y
3 1/6/2004 M
3 1/7/2004 N

I need to pick up the last two events (by date) and organise them as
follows:

ID Second last date Second last event Last date Last event
1 1/2/2004 B 1/3/2004 C
2 1/4/2004 X 1/5/2004 Y
3 1/6/2004 M 1/7/2004 N


Any easy way of doing this?

Thanks, Utkarsh