I think the window functions should be of help here.

Please repost the data I am not able to get the data you have posted.