Hello,



I had an online form that was a survey. I've exported the data into an excel spreadsheet. I'd like to use those answers and print them out page by page, with all the answers to person 1 on one page, all answers by person 2 on second page, etc.

Is there a function in word to take data rows/columns and insert them as specific fields (similar to the mail merge function, i'm guessing)


Example (database file):



Final Outcome (Word Doc):
Page 1 - Jon:

Apples or Oranges
Apples

A, B, or C
B

Day of the week?
Monday

Page 2 - Sue:

Apples or Oranges
Oranges

A, B, or C
A

Day of the week?
Friday

Page 3 - Jeff (etc.)
Apples or Oranges
Apples

A, B, or C
C

Day of the week?
Wednesday