Consolidate data

[inwoodpcpro]

Hello All,

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 have attached a sample excel file which illustrates what i want to accomplish.

Sheet 1 shows existing data, Sheet 2 shows what i want it look like.