Hi all Excel experts,
Can anyone show me how to replicate a row based on information in a designated column.
For example:

A B C D
1 MAI White 5
2 TIN Orange 3
3 CAN Yellow 3
4 YIN ME 4
5 YANG BL 5

Col D indicates the number of rep. So, the first record will be replicated 5 times. Second record is replicated 3 times and so on.

Thanks so much.