My challenge for today: resorting & rearranging data to work in complex mail merge

[sharicn]

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:

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

2

1

3

1

4

5

2

1

1

2

<tbody>
</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

 

[sharicn]

After more searching today I found this most excellent code from Peter:

http://www.mrexcel.com/forum/excel-...-converting-multiple-columns-into-rows-3.html

I still need to figure out the merge issue, but my largest problem is now solved. Happy camper here.

/S