I have a table with 3 columns,
participant_id, question, answer. for each participant, there will be five question.
How do fetch a report like against each participant each question as a column header and answer as value. So in report for each participant there will be one entry in report?
expected output: group using participant_id and each question should be the column header and custtusponding answer will be the column value.