My survey has 13 questions, categorised to 4 groups of subjects.
I want to create a new column for each subject.
example: columns 1, 5, and 6 represent the subject "emotional approach".
I want to create a processed column "emotional approach".
The data that will appear in the cell of the new column will be the means of the cells of columns 1, 5, and 6.
Please help, I did id two years ago, and forgot how to do it.