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,
Bookmarks