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!

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?


--
Thanks,
Shane Devenshire


"Brian H" wrote:

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!

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.. :-)


"ShaneDevenshire" wrote in
message ...
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?


--
Thanks,
Shane Devenshire


"Brian H" wrote:

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!

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)

"Brian H" wrote in message
news:4B7Eh.1138344$R63.177466@pd7urf1no...
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
Bob Jan-07 5 5 3 3 4 4 Comments
Bob Feb-07 4 3 5 5 4 3 Comments
Bill Feb-07 3 2 3 2 3 4
Bob Mar-07 1 5 5 5 5 5
Bill 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!