We have a report on Metric result (asmt_etric_result) and when we export the report to excel, it exports in a way that each question is exported as row and answer as a column. we want the other way - All questions of the survey as single columns and each answer in a metric instance as each row. so basically we want all questions are columns and each survey answers to those respective questions are as one row as shown in screenshot below. but not able to export in this way. I tried the pivot option but the name (string value ) of the answer is not an option to select when I am trying Pivot method. Wondering if anybody had same requirement and how they were able to do it.
