Apr 16 2021 07:12 AM
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!
Apr 16 2021 07:31 AM
SolutionApr 16 2021 10:43 AM
Apr 16 2021 07:31 AM
SolutionFormula in attachment.
A better solution might be PowerQuery/unpivot