Gathering Comments from Survey Data

[Brian H]

I have raw survey data in a table on a single sheet. The data is the month
the survey was done followed by a few survey ratings then a comment. Some
surveys come back with out a comment so those lines are just the month and
the question data. Example:

Jan-07 5 5 3 3 4 4 Comments
Feb-07 4 3 5 5 4 3 Comments
Feb-07 3 2 3 2 3 4
Mar-07 1 5 5 5 5 5
Mar-07 2 3 4 3 4 3 Comments

The months are Dates, the first of each month to be exact and the Comments
are unlimited (at this time) text fields.
I have a summary sheet that is showing the totals by month running across
the sheet. What I would like to do is gather the Comments under the summary
running down other then using a pivot table. When I did use a table it
stretched the summary table out of whack. Even if I can only show one month
at a time it would be OK.

Thanks for your time and thoughts!

 

[ShaneDevenshire]

Hi Brian,

Probably the easiest way to do this is VBA, however it can be done with a
formula approach, although its quite involved. Which approach would you
prefer?

 

[Brian H]

I have been trying to avoid VBA, but I would take ether. We have a lot of
staff who tinker with VBA and get into the code on shared docs a change them
for the better. So far I have a nice locked down file..

 

[Brian H]

Drat, new update...
The data table has changed. Each row will now include a name on it.
We will be needing to limit by the names. (I guess I missed a memo)

I have raw survey data in a table on a single sheet. The data is the month
the survey was done followed by a few survey ratings then a comment. Some
surveys come back with out a comment so those lines are just the month and
the question data. Example:

Edited Data