Hi,

I need to create a bunch of reports to display attributes about various programs. There a dozens of fields that I am trying to merge in to a single word document and am wondering if it is possible to set up a merge to read multiple rows of excel in to a single report. For example, here are 2 columns from the data table that I'm trying to merge in to a single word doc (please forgive the alignment, I tried to space out the columns but it appears to have been truncated in the post):

Program Name Year
Name 1 2000
Name 2 2006
Name 3 2012
Name 4 2017

In the single word document, I've set up text boxes and would like the info displayed as follows:

Name 1 Name 2 Name 3 Name 4
2000 2006 2012 2017

The issue is if I use the 'Program Name' and 'Year' column headings from the data table, it keeps returning the first record like this:

Name 1 Name 1 Name 1 Name 1
2000 2000 2000 2000

Is there a way to set up either the data table or the word document to read each row of data or do I need to transpose all of the data in to a single row with distinct column headings for each merge field? Any advice is much appreciated, thanks!

DS