Hi everyone,
We are holding a raffle and folks are buying their raffle tickets online. There are multiple items for which tickets can be bought, and you can buy more than one ticket for each item. The raw data from my online program comes through as follows:
<tbody>
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
</tbody>
What I'm trying to do is bring this information into Excel and arrange it in such a way that allows me to print the correct number of raffle tickets for each item. So I need to find a way to arrange the data (I'm thinking so that the columns become rows and each person has 10 rows rather than one, if that makes sense) and then a way to set up my merge so that the appropriate number of tickets are printed for each item (I may be able to do with a catalog merge or directory merge depending on whether I use Word or Publisher).
Suggestions to get me started?
Thanks in advance!
Shari
We are holding a raffle and folks are buying their raffle tickets online. There are multiple items for which tickets can be bought, and you can buy more than one ticket for each item. The raw data from my online program comes through as follows:
First Name | Last Name | Email Address | Raffle Item1 | Raffle Item2 | Raffle Item3 | Raffle Item4 | Raffle Item5 | Raffle Item6 | Raffle Item7 | Raffle Item8 | Raffle Item9 | Raffle Item10 |
Shari | Smith | shari@smith.org |
<tbody>
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
</tbody>
What I'm trying to do is bring this information into Excel and arrange it in such a way that allows me to print the correct number of raffle tickets for each item. So I need to find a way to arrange the data (I'm thinking so that the columns become rows and each person has 10 rows rather than one, if that makes sense) and then a way to set up my merge so that the appropriate number of tickets are printed for each item (I may be able to do with a catalog merge or directory merge depending on whether I use Word or Publisher).
Suggestions to get me started?
Thanks in advance!
Shari