title: How do I recode excel data into new rows?
body: <p>I want to recode a set of GDP data, but I can't find a command that gets it into a format that I could merge into my other data sets.</p>
  <p>The data currently looks like</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Country Name</th>
  <th style="text-align: center;">1960</th>
  <th style="text-align: right;">1961</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">Aruba</td>
  <td style="text-align: center;">5,000,000</td>
  <td style="text-align: right;">5,400,000</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>And so on for each year, but I need it to look like</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Country name</th>
  <th style="text-align: center;">Year</th>
  <th style="text-align: right;">Amount</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">Aruba</td>
  <td style="text-align: center;">1960</td>
  <td style="text-align: right;">5,000,000</td>
  </tr>
  <tr>
  <td style="text-align: left;">Aruba</td>
  <td style="text-align: center;">1961</td>
  <td style="text-align: right;">5,400,000</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I've been screwing with the data with r, excel, and SPSS, and I don't know how to do this in any of them. Any advice would be appreciated.</p>