I am trying to use the advance filter option - multiple criteria and multiple columns

Hi everyone!

I am running into a bit of a problem using the advanced filter option. any help is much appreciated.

I attached a screen shot in the link below So, just to get an idea, this file has over 1,000 rows. I'm trying to filter the data like this: if Q-3 from header, 'Question' is equal to A from header, 'Answer'... then I want it to show Q-1 (Question header), answer (header) A and B

Right now, when I use the advanced filter option, it's showing all the Q-3 s with the answer, 'A' (which is what I want) and all the Q-1s answer, A and B regardless of Q-3.

I just want Question:Q-1, Answer: A and B, to show IF Question:Q-3 = Answer:A

http://imgur.com/EmtqyVu

Any idea what I should do?

Thank you.