Google Sheets: Formula that returns same number of rows based on cell values

Question

I have a list of users and a value that denotes how many times I want to return the user's name.

How do I set up a formula that helps me output this?

Answer 1

try:

=INDEX(QUERY(FLATTEN(IFERROR(SPLIT(REPT(A2:A&"×"; B2:B); "×"))); 
 "where Col1 is not null"; ))