Consolidating Multiple Rows into Columns

Summary

We are trying to get candiate Q&A questions to appear as columns vs. rows

Content

I am trying to write a formula to convert the questions and answers from the candidate Q&A section so that they report as additional columns (1 column for each questions, with responses included in the data). Versus adding an additional row for each question/answer.  I am using the formula below, but it does not appear to be working.

 

EVALUATE_AGGR('MAX(CASE WHEN %1 = %2 THEN %3 END)' AS CHARACTER(200),"Candidate Q&A"."Question Description (BL)" ,'Candidate Response',"Candidate Q&A"."Answer (Choice) (BL)" ).