Question

An analyst receives a survey export where each respondent is one row, and satisfaction scores for five products appear in five separate columns (Product_A_Score, Product_B_Score, etc.). To build a visualization tool that plots average score by product, the analyst needs a table with columns for RespondentID, Product, and Score. Which transformation should the analyst apply?

Accepted Answer

Unpivot (melt) the five product score columns into two columns representing product name and score

Answer

Pivot the data from long to wide format using product name as the new column headers

Answer

Perform an inner join between the survey table and a product dimension table

Answer

Aggregate the five score columns into a single average column per respondent