Generate Column of raw data based on frequency table in Excel -

i have column of numbers , second column of numbers. second column of numbers contains frequency of numbers in left column.

i want create third column of numbers has raw data.

example:

a  b 1  5 3  2 4  4 

column c like:

c 1 1 1 1 1 3 3 4 4 4 4 

how can in excel? thanks!

based on data in a1:b3, in c1, array formula**:

=if(rows(a$1:a1)>sum(b$1:b$3),"",index(a$1:a$3,match(true,mmult(0+(row(a$1:a$3)>=transpose(row(a$1:a$3))),b$1:b$3)>=rows(a$1:a1),0)))

and copied down until start blanks results.

regards

**array formulas not entered in same way 'standard' formulas. instead of pressing enter, first hold down ctrl , shift, , press enter. if you've done correctly, you'll notice excel puts curly brackets {} around formula (though not attempt manually insert these yourself).