I have a mail merge that has data in Excel. The word merge needs to be a table. The table has a first row with the field from column A. Then the next row in the word table is split in 2 columns. This is where the next 5 fields from excel go. They go in the first column of the word table, like an address block. The next record should be in the right column of the table, etc, if the first column at the top of the word table is the same as the previous row in excel. The merge should make a new page with a new table, only if the first column is different than the previous record. Looking around, I am not sure how to do this.



So let's say this is a data set of music. It would be the name of the CD, and then who to send it to. Each row of excel would be like this:
CD,Recipient1,Add1,City,State,Zip
CD1,johndoe,1mainst,chicago,ny11223
CD1,janesmith,2mainst,chicago,ny11223
CD2,mikeanderson,3broadst,chicago,ny11223
CD3,bethchilds,4hollywoodblvd,chicago,ny11223
CD3,sarahmanning,5pennsilvaniaave,chicago,ny11223
CD3,tatianamaslany,6blahblahst,chicago,ny11223

So the word doc would have cd1 at the top row of a table. The 2nd row split in 2 columns, so that the first recipient block goes in the first column. The next record is the same cd, so it just goes in the next column in the word table. If the CD name changes, then we go to a new page and put the new CD in a new table as the first table row/column (centered).

Does this make sense? If anyone can help, I would appreciate it. I found a tutorial online about directories and catalogs, but it is really confusing.