Auto populate cells

Good Afternoon,
I'm trying to track down numbers on a running race. The participants will run 5 laps around a 1/2 mile course and I want to track their numbers as they complete their laps.
I want to enter ALL numbers for ALL laps in columb A, starting at A1 thru A.... Now some racers will probably be lapped, therefore I want to automatically populate column B for runners who complete their second lap and automatically populate column C for the ones that complete their third lap and so on...until the fifth lap. Remember that I always want to enter numbers on column A. Therefore I will have repeated numbers in column A, that's OK. Here is an example of all this.

COLUMN A COLUMN B COLUMN C
2 --------- ---- 5 -------------- 5
3 --------- ---- 10
5 --------- ---- 21
21 --------- --- 1
10
1
8
4
5
10
25
99
5

So, as numbers repeat in column A, they should get populated in the other columns. As you see number 5 completed three laps and should populate column C.
If you could help with the formula to use I would really appreciate it. Please try to avoid macros. I don't know how to use them yet. Thank you.