[SOLVED] renumber numbers?

say column A is a list of numbers:

[A]
1
1
1
1
1
2
2
2
3
3
3

say i would like to re-number the numbers to the following 1=29, 2=40, 3=5

[A]
29
29
29
29
29
40
40
40
5
5
5

is there any way to accomplish this?
thanks.