I have a table in Word with 4 rows and 4 columns. In Excel I have a 4 column spreadsheet and I want to merge the data form the spreadsheet into the Word document. I've set up a data merge in Word and have inserted the field codes that relate to the 4 columns in the Excel spreadsheet into the first 4 rows of the table in Word. I then copied these 4 field codes and pasted them into the other rows of the other 3 columns in the table.
I was hoping that when I merged to a separate document that the first row in the spreadsheet would merge into the first column, the second row into the second column, the third into the third and the fourth into the fourth. Then I thought it would automatically create a new page and the rest of the spreadsheet rows would merge into the columns of the new pages.
This didn't happen though. Instead it used 1 page for each row of the spreadsheet and just copied the values of the first column into the other 3 columns so there were 4 instances of each row of the spreadsheet on each page.
Is it possible to have the data merged as described above instead of what's happening now?
Thanks for any help.