Hi,

I have the following problem,

I have a two clumn numbers like this,

1 5
2 4
3 8
4 9
5 3
6 2
------
------
------
168 2
169 4.

I want to fillup cels automatically with the numbers of column 1 with the times of corresponding column 2. Example, the number 1 of column should be filled up 5 times (as shown in column 2) like, 1 1 1 1 1 and 2 as 2 2 2 2 and so on. Ofcourse i could do it in perl using for loop. I dont have idea of programming in excel. Can anybody help me.