#1
|
|||
|
|||
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add multiple rows to Excel 2010 table at cursor position | C J Squibb | Excel Programming | 12 | 11-07-2013 07:35 AM |
Applying a conditional format to multiple rows | secoo140 | Excel | 1 | 10-12-2013 07:19 PM |
Printing - merged document, multiple sections | nikkifox | Word | 2 | 04-09-2013 12:54 AM |
borders disappear from merged cells when pasting from excel | joba | Word | 0 | 09-10-2012 11:35 AM |
Formatting Merged Time Values Between Excel & Word | JennEx | Mail Merge | 1 | 07-12-2012 02:54 PM |