How to add values from column to Dynamic column in OTBI

Hi All,

We have a requirement, to add one column values (Answer) to Dynamic columns (Question). Please see the below screenshot to clearly understand the requirement.

We’ve tried using a Pivot table and were able to get the ‘Question’ column as dynamic columns. However, the answers are not appearing under the corresponding questions.

Thank you in advance.

Regards,

Chaitra