This is somewhat of a wide open question, as it potentially involves surveys, rules,  and reports.

We are using the survey question type of “Matrix” for 4 parallel surveys, which results in 4 different datasets and flattened answer tables.

Each of these surveys has 8-10 attributes/ questions in the matrix- but when you look at the data, the flattened file displays each potential answer as its own column in the MDA table, making it impossible to run averages or display the full survey results in a tabular report on a Dashboard.

Does anyone have a good way to merge or transform the data set so that all of the response options for a specific matrix question is contained in a single column in a new customer object?