In columnA i have a range of numbers that can vary in length and in column B, but it is a continuous range (no blanks) beside i have a frequency. I would like each value in column a to be repeated b times below

eg A B
1 22424 3
2 242424 2
3 7577 1
4 575437 2
5 5574 1


and i wish to create a list in column C eg

22424
22424
22424
242424
242424
7577
575437
575437
5574

I am not great at macros, but i am sure there must be a fairly simple way to automate this. can anyone help

Thanks

Dav