Excel Multiple Rows Merged into Word (Vertical Format)
I am collecting scores on an assessment from two reviewers in a spreadsheet. Each student will ultimately have two rows in the spreadsheets, each with the scores from a particular reviewer.
I saw how to use a Directory to merge the data in the spreadsheet into a Word document, using the student ID as a key.
However, ideally, I would like to merge the data into a table in Word with three columns:
COLUMN A: Task that was assessed (there were 15 tasks_
COLUMN B: Reviewer #1's scores
COLUMN C: Reviewer #2's scores
I am looking for a way to generate a 1-page report for each student, that includes this table, with the 15 tasks listed, and each reviewer's score to the right of each task.
However, I cannot find a way to merge this information in COLUMNS (or vertically). Every example shows how to merge each row of data from the spreadsheet as a separate row in a table (horizontally). I prefer this layout because the text under TASK (rather than blah blah) is longer, and visually looks better in a row, rather than as a column heading.
Task | Reviewer #1 | Reviewer #2
Blah blah #1 | 3 | 2
Blah blah #2 | 2 | 2
Blah blah #3 | 2 | 1
I only find ways to do this:
Reviewers | Task 1 | Task 2 | Task 3
1 | 3 | 2 | 2
2 | 2 | 2 | 1
Ideas?
|