Hello,
I am having trouble transposing an excel (SPSS) dataset. I got the dataset in the form shown below and I need to transform it into a workable form (like it is shown in the lower part of the picture). It is a very large dataset (cca 1500 participants). I tried to do "restructure" - cases intro variables but SPSS says "The INDEX values for case ## have occurred before in the cases with the same ID values. This command is not executed". I think maybe because certain participants have filled in some questionnaires more than once but I am not sure.. I am not great at SPSS or excel and it would be amazing if someone was able to help me here!
I am having trouble transposing an excel (SPSS) dataset. I got the dataset in the form shown below and I need to transform it into a workable form (like it is shown in the lower part of the picture). It is a very large dataset (cca 1500 participants). I tried to do "restructure" - cases intro variables but SPSS says "The INDEX values for case ## have occurred before in the cases with the same ID values. This command is not executed". I think maybe because certain participants have filled in some questionnaires more than once but I am not sure.. I am not great at SPSS or excel and it would be amazing if someone was able to help me here!
