Hello everyone, new here.
I am trying to design a quick prize ballot system, and I've hit a snag.
I have a query that I run that tells me the user and number of ballots they have earned for our prize system. To simplify it, there are two columns:
Name Ballots
Tammy 5
James 2
Alice 3
...etc
The formual that I am using is a random formula in excel, and it works great, except it expects the ballots to be on seperate lines. I need to transform the above to this:
Tammy
Tammy
Tammy
Tammy
Tammy
James
James
Alice
Alice
Alice
...based on the qty of ballots.
Any ideas?
Thanks for the help!
Tammy
I am trying to design a quick prize ballot system, and I've hit a snag.
I have a query that I run that tells me the user and number of ballots they have earned for our prize system. To simplify it, there are two columns:
Name Ballots
Tammy 5
James 2
Alice 3
...etc
The formual that I am using is a random formula in excel, and it works great, except it expects the ballots to be on seperate lines. I need to transform the above to this:
Tammy
Tammy
Tammy
Tammy
Tammy
James
James
Alice
Alice
Alice
...based on the qty of ballots.
Any ideas?
Thanks for the help!
Tammy