title: How to "flatten" or "collapse" a 2D Excel table into 1D?
body: <p>I have a two dimensional table with countries and years in Excel. eg. </p>
  
  <pre><code>        1961        1962        1963        1964
  USA      a           x            g           y
  France   u           e            h           a
  Germany  o           x            n           p
  </code></pre>
  
  <p>I'd like to "flatten" it, such that I have Country in the first col, Year in the second col, and then value in the third col. eg.</p>
  
  <pre><code>Country      Year       Value
  USA          1961       a
  USA          1962       x
  USA          1963       g
  USA          1964       y
  France       1961       u
                ...
  </code></pre>
  
  <p>The example I present here is only a 3x4 matrix, but the real dataset i have is significantly larger (roughly 50x40 or so).</p>
  
  <p>Any suggestions how I can do this using Excel?</p>