Dear all friends,

I need help for this case. I have a set of data, let me type in text :

Column A | Column B | Column C | Column D |
Name | *** | Hobby | value for duplicate rows

John | Male | Soccer | 12
Bryan| Male | Swim | 8
Dave | Male | Tennis | 28
Tracy | Female | Read | 9
Steve | Male | Golf | 38

I need to copy each rows based on value in right colum. for example i need to copy

John | Male | Soccer | 12

as much as 12 times, and then copy

Bryan| Male | Swim | 8

as much as 8 times after John

and so on until last row.

Please help me to sove this problem.

Thx,