Consolidate results from database query

[inwoodpcpro]

I'm new to the forums here. Could not find what I'm looking for. If this was answer in a previous post, please point me there.

I have data on an excel sheet that was pulled from a database. There is a record for each question in a test along with the choices of the test. Problem is there are 5 records for each question, one for each choice.

I would like to pull out the choices and make then a column instead of a row.

I dont see a way to attach a file on this forum. On some posts it looks like people make the table right in the post. ANy ideas how I can do that so i can show my sample?

Basically I have the results like this
The columns are:

Test, Test Name, Question Number, Question Text, Choice, Choice Text

1 Test1 1 Question 1 A Choice A
1 Test1 1 Question 1 B Choice B
1 Test1 1 Question 1 C Choice C
1 Test1 1 Question 1 D Choice D
1 Test1 1 Question 1 E Choice E
1 Test1 2 Question 2 A Choice A
1 Test1 2 Question 2 B Choice B
1 Test1 2 Question 2 C Choice C
1 Test1 2 Question 2 D Choice D
1 Test1 2 Question 2 E Choice E

should end up something like this

Test, Test Name, Question Number, Question Text, Choice A, Choice Text, Choice B, Choice Text, Choice C, Choice Text, Choice D, Choice Text, Choice E, Choice Text

1 Test 1 1 Question 1 A Choice A B Choice B C Choice C D Choice D E Choice E
1 Test 1 2 Question 2 A Choice A B Choice B C Choice C D Choice D E Choice E

Hope that makes sense to someone. Thanks!