View Single Post
 
Old 11-14-2013, 02:09 PM
ats1025 ats1025 is offline Windows XP Office 2007
Novice
 
Join Date: Nov 2013
Posts: 2
ats1025 is on a distinguished road
Default 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?
Reply With Quote