title: Shaping SPSS data to structure it like Excel table format
body: <p>I have a SPSS database with several variables and scores for each one depending on the case row. I'd like to shape this to Excel format, so there will be one column called variable and below just the name of every SPSS variable (before in several columns) and next to it a column called scores and the respective score for every variable. Don't know how to do it.</p>
  
  <p>Visual example:</p>
  
  <p><em>SPSS format</em></p>
  
  <p>Country | Variable 1 | Variable 2 | Variable 3...</p>
  
  <p>USA | 80 | 45 | 34...</p>
  
  <p><em>Excel format</em></p>
  
  <p>Country | Variable | Score</p>
  
  <p>USA | Variable 1 | 80</p>
  
  <p>USA | Variable 2 | 45</p>
  
  <p>USA | Variable 3 | 34</p>