Compile question responses currently in Excel file into a summarized by question Word file

[Dawn null]

Hi! I have collected data from a questionnaire and it is now in an Excel format.  The questions are in Row 1 at the top, respondents are in Column A with the answers under each question column. I need to convert this information into a Word Document organized by the Question.  Below is an example of what I'm looking to do. I *think* I should be able to do this using a Directory Mail Merge, but have been unsuccessful so far. I would really appreciate any thoughts on how best to do this.  Thanks!

Excel Sheet setup: 

	Question 1	Question 2	Question 3	Question 4
Respondent 1	Text is in paragraph form	Text is in paragraph form	Text is in paragraph form	Text is in paragraph form
Respondent 2	Text is in paragraph form	Text is in paragraph form	Text is in paragraph form	Text is in paragraph form
Respondent 3	Text is in paragraph form	Text is in paragraph form	Text is in paragraph form	Text is in paragraph form

Preferred format for Word document:

Question 1

Respondent 1 answer

Respondent 2 answer

Respondent 3 answer

Question 2

Respondent 1 answer

Respondent 2 answer

Respondent 3 answer

[#2]

Yes, directory merge should be able to do this for you. You'll need to have a label for your list of respondents (eg: "Respondent" in A1 cell in your table)