title: SPSS data restructuring
body: <p>I need to change my SPSS data restructuring from 
  this </p>
  
  <pre><code>ID1:reading comprehension 1,reading comprehension 2 reading comprehension 3,
  ID2:reading comprehension 1,reading comprehension 2 reading comprehension 3,
  </code></pre>
  
  <p>to</p>
  
  <pre><code>ID1 reading comprehension 1
  ID1 reading comprehension 2
  ID1 reading comprehension 3
  </code></pre>
  
  <p>this is the syntax I have tried:</p>
  
  <pre><code>SORT CASES BY ID PunkteT1 PunkteT2 PunkteT3 MW1 MW2 MW3 IMW1 IMW2 IMW3 Vorwissen_T1 Vorwissen_T2 
      Vorwissen_T3 Interesse_T1 Interesse_T2 Interesse_T3 UMW1 UMW2 UMW3.
  CASESTOVARS
    /ID=ID
    /INDEX=PunkteT1 PunkteT2 PunkteT3 MW1 MW2 MW3 IMW1 IMW2 IMW3 Vorwissen_T1 Vorwissen_T2 
      Vorwissen_T3 Interesse_T1 Interesse_T2 Interesse_T3 UMW1 UMW2 UMW3
    /GROUPBY=VARIABLE.
  </code></pre>
  
  <p>It doesn't work out because of this warnings:</p>
  
  <blockquote>
    <p>In case 2, an invalid index value was determined. String index values
    can not be empty. Numeric index values must not be negative integers.
    The execution of this command has been stopped.</p>
  </blockquote>
  
  <p>I already tried to solve this but without any success.</p>
  
  <p>Do you have any ideas?</p>
  
  <p>Thanks,
  Kathrin</p>