First of all, I am very much at a "Beginner's level" so I'm not sure if what I'm asking for is possible but I will explain, to the best of my ability, and appreciate any help that's provided.

Below are two very basic tables to add a visual to my question. The first one just lists the test questions, which multiple choice answer is correct, and the possible answers. The second shows the questions, the correct multiple choice answer, the multiple choice answer selected, and the person that answered:

```
+---------------------------------------------------------------------------------+
|                                   Test Questions                                |
+-----------------------------+--------+----------+----------+----------+---------+
| id | QuestionText           | Answer | AnswerA  | AnswerB  | Answer C | Answer D|
+----+------------------------+--------+----------+----------+----------+---------+
| 1  | What Color is the Sky? |   C    | Red      | Green    | Blue     | Purple  |
+----+------------------------+--------+----------+----------+----------+---------+
| 2  | What has one wheel?    |   A    | Unicycle | Tricycle | Bike     | Car     |
+----+------------------------+--------+----------+----------+----------+---------+
| 3  | Who is the President?  |   B    | Bush     | Obama    | Clinton  | Kennedy |
+----+------------------------+--------+----------+----------+----------+---------+

+---------------------------------------------------------+
|                       Test Results                      |                        
+-----------------------------+--------+----------+-------+
| id | QuestionText           | Answer | Response | EE    |
+----+------------------------+--------+----------+-------+
|  1 | What Color is the Sky? |   C    |    A     | Bill  |
+----+------------------------+--------+----------+-------+
| 2  | What has one wheel?    |   A    |    A     | Bill  |
+----+------------------------+--------+----------+-------+
| 3  | Who is the President?  |   B    |    D     | Bill  |
+----+------------------------+--------+----------+-------+
| 4  | What Color is the Sky? |   C    |    C     | Susie |
+----+------------------------+--------+----------+-------+
| 5  | What has one wheel?    |   A    |    B     | Susie |
+----+------------------------+--------+----------+-------+
| 6  | Who is the President?  |   B    |    A     | Susie | 
+----+------------------------+--------+----------+-------+

```

After joining the tables, I want to combine the Answer column with the AnswerA column, AnswerB column...etc, based on the letter in the Answer column. Much like this:

```
+----------------------------------------------------------------+
|                         Test Results                           |
+-----------------------------+---------------+----------+-------+
| id | QuestionText           | CorrectAnswer | Response |   EE  |  
+----+------------------------+---------------+----------+-------+
| 1  | What Color is the Sky? |   C  Blue     |    A     | Bill  |
+----+------------------------+---------------+----------+-------+
| 2  | What has one wheel?    |   A  Unicycle |    A     | Bill  |
+----+------------------------+---------------+----------+-------+
| 3  | Who is the President?  |   B Obama     |    D     | Bill  | 
+----+------------------------+---------------+----------+-------+

```

Any suggestions?