Hi guys,

I need a hand to solve this one.
I have two columns, the first contains the data to be copied, the second contains the frequency it will be copied with.

I need to copy this data to another worksheet so it will contain one row but the first cell will be copied three times, the second only once, the third five times and so on.

Thanks a lot. Cheers.

R0008DJ443 3
R0105DJ426 1
R0107DJ427 5
R0205DJ866 16
R0208DJ946 3
R0308DJ946 1
R0406DJ437 17