Georgiana,
Again, not completely sure what you want, but....
Have you tried sorting your data on the category column entries? In that way
at least all questions/answers per category are combined.
Next thing I would suggest is to make different worksheets for the various
categories, which could be close to what you want; click on the worksheet for
all (and only those) questions/answers related to that category


"Georgiana" wrote:

Hi rdwj, i have tried the auto filter and used the custom version to create
what it should look like. yes 6 columns, I want to click on the category and
just how that one category with all the questions and answers. e.g

category question response
Anti-money lndrg policies 1. Does Vendor.. If yes,...
""" "" 2. Are all... If yes,...

Business Ethics 1. Can we... No, ...
"" "" 2. We can... yes....
""" "" 3. We should... We can..

Through filtering, it looks like the above, I thought of something else. If
number the category 1 through 25, I want to list all the questions under
Category 1 not everything. can that be done? I am sorry, I am not sure how
else to explain it.

"rdwj" wrote:

Still don't understand. 6 columns,
category
question
response
source
use by
contact

so where do you want your dropdown? in a seperate sheet?
If you just want to shows all Q&A's for one category I am sure you would
know to apply the autofilter...


"Georgiana" wrote:

Hi rdwj, thank you for taking the time to respond. You are right except in
your assumptions below. I actually have 6 columns including a category
column, a question column, response and source column, use by and contact
columns and I want to be able to use a drop down bar on each category (25 of
them) to expand the category's many questions and answers, and populate
across the spreadsheet like I'd do a regular filter. So If I hit the category
column, it will show all the questions related to that category and all the
questions and answers relating to that category. The questions and responses
are more than one. I would attached the spreadsheet but this source doesn't
show how I can attach a document. Thank you.

"rdwj" wrote:

not sure I fully understand the problem; you have a list of questions, one of
which can be selected through a drop down list - after which you want the
answer displayed in a second cell?
If so, a assume you have a table with the questions in col a and the answers
in col b. Suggest that you use a lookup (ensure that the list is alphabetic
on the questions) to lookup the answer.

"Georgiana" wrote:

I have a spreadsheet with questions and answers. I would like to have each
category (or question) listed once using a drop down arrow, then expanding
for the answers. Thank you.