I have an Excel file with data from 60 or so respondents to a questionaire.
I have all my raw data on one worksheet. On another worksheet I have totals
for the various questions broken out in various ways. I would like to create
another worksheet that lists the answers to an open-ended question at the end
of the questionaire. Less than half of the people responding wrote comments
so I don't want to include blanks. I'd like to have a consolidated list of
the comments in a tidy, separate sheet.

As yet, I've been unable to figure out how to do this. Any help would be
appreciated.