I got this file with the trivia questions and answers.

The sheet in excel looks something like this :

A column :
Question 1
a) Answer 1
b) Answer 2
c) Answer 3
d) Answer 4

Question 2
a) Answer 1
b) Answer 2
....

B column :
+ mark in the row where the answer to the question is right.


My question is : can I make a new sheet with the question numbers and the
right answers only ? It should look something like this :

1 a
2 b
3 d
4 c
5 d
....

Ty all in advance !

Marko