Recruitment Candidate Question and Answers OTBI Report Structure

Summary:

I have been trying to change the layout of my OTBI report to have the candidate questions per column with their answers per row to avoid having multiple rows per person.

I converted the table into a pivot table.

I can get the questions as column headers, but no matter what I do I can't get the questions below as rows.

Even though there is data to return (when formatted as a table), when I move it to a pivot table it returns the fields blank.

Content (please ensure you mask any confidential information):

Not using the pivot table: