Generate list based on value & frequency

[ExcelNov2021]

Hi there,

I have a list of names in one column and a frequency value in the other column.

E.g.

Name. Frequency

Dave. 2
Pete. 1
Tony. 4


Is there a formula that will generate a new list with all individual entries.

I.e.

Dave
Dave
Pete
Tony
Tony
Tony
Tony

Thanks in advance,

[JohnTopley]

With Name/Frequency in A2/B2 and down

in C2 put 0 (zero)

in C3

=C2+B2

Copy down to last name

in E2

=IF(ROWS($1:1)<=SUM($B$2:$B$50),INDEX($A$2:$A$50,MATCH(ROWS($1:1)-1,$C$2:$C$50,1)),"")

Drag down until you get a blank

[FlameRetired]

Similarly with names/frequencies in A2/B2 and down

Please Login or Register  to view this content.

In Office 2007 if that does not return what you expect you make have to commit this formula as an array formula.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.