Converting Frequency Table into List

[TDRKZ]

I apologize if the title doesn't perfectly reflect what I am trying to do, as I'm not sure what to call it exactly. I am looking for a way to convert a frequency table back into data form.

I.E.
You have rankings from 1 to 4 and the frequency of each occurance

Rank, Frequency
1, 4
2, 3
3, 5
4, 1

I would like it to turn into the original data format (vector/list)
1
1
1
1
2
2
2
3
3
3
3
3
4


Thanks

[martindwilson]

see attached

[TDRKZ]

Thanks! This works perfectly. Can you explain the steps that "=IF(ROW(A1)>SUM($B$2:$B$200),"",INDEX($A$2:$A$200,LOOKUP(ROW(A1),$C$2:$C$200,ROW($A$1:$A$100))))" goes through just for future reference or if I need to adjust.