Reporting on Interview Evaluations

Summary

I would like to have the questions on an interview evaluation questionnaire appear as columns rather than multiple rows per question.

Content

Currently we have the ability to report on interview evaluation questionnaires answers. I am attempting to have each of the questions & skills function as a column, instead of repeating rows for each question.

So far, I've come up with the following custom formula for each of the skills and questions:

CASE WHEN "Submission Evaluation Questionnaires"."Submission Evaluation Skill Name (BL)" IN ('Overall candidate rating / evaluation') THEN "Submission Evaluation Questionnaires"."Submission Evaluation Skill Rating Name (BL)" END

This, unfortunately, gives me a step ladder of sorts (see image below), where there is a NULL value separating each of the question answers... Any way I can get around it?