Allowing names to appear multiple times in a list, depending on a value in the list

New Contributor

Hi!  I want to create a list of names to be printed for raffle tickets.  I have a matrix of how many tickets each person purchased.  If Bill bought 5 tickets, I want his name to appear five times in the list.  See attached worksheet for matrix and desired output.


Thank you so much for your help!



2 Replies
best response confirmed by jasper1979 (New Contributor)


Formula in attachment. 

A better solution might be PowerQuery/unpivot