title: Reshape wide data with multiple categories to tall in excel
body: <p>I have a dataset in excel that Looks like this:</p>
  
  <pre><code>Date   Country1-GDP   Country2-GDP  Country1-Unemp   Country2-Unemp
  </code></pre>
  
  <p>and I would like to produce a normalized dataset like this:</p>
  
  <pre><code>Date1   Country1_Name   Country1-GDP   Country1-Unemp
  Date1   Country2_Name   Country2_GDP   Country2_Unemp
  Date2   Country1_Name   Country1-GDP   Country1-Unemp
  </code></pre>
  
  <p>I would like to do this in VBA so that I can call it as a macro directly in excel after I pull my data in .. </p>
  
  <p>any thoughts or pointers?</p>