title: Excel converting columns to rows
body: <p>I have a large Excel sheet (approx 150 columns x 7000 rows and growing every day) but need to extract information in a better way.
  I don't have access to database software, only Excel.
  I've managed to get the result I want using normal Formulas, but the file size is almost 100mB (up from 4mB originally) and not workable - it's just too slow.
  I created a pivot table that only partially solves the problem.
  I'm new to VBA, so I tried a few examples on here to try to learn but most are too complex for me at the moment.
  In theory, "<a href="https://stackoverflow.com/questions/3698442/convert-row-with-columns-of-data-into-column-with-multiple-rows-in-excel">Convert row with columns of data into column with multiple rows in Excel</a>" looks to partially resolve my problem, but I just can't get it to run! While I can see the code in the module, it does not appear in the macro list when I press the run button.
  Here is what I'm starting with-</p>
  
  <pre><code>Name1   Name2   Location    Subject1    Subject2    Subject3
  Fred    Jones   England     Spanish     Maths       English
  Peter   Brown   Germany     English     (empty)     Maths
  Erik    Strong  Sweden      Chemistry   English     Biology
  </code></pre>
  
  <p>Required result -               </p>
  
  <pre><code>Name1   Name2   Location    No.         Type    
  Fred    Jones   England     Subject1    Spanish 
  Fred    Jones   England     Subject2    Maths   
  Fred    Jones   England     Subject3    English 
  Peter   Brown   Germany     Subject1    English 
  Peter   Brown   Germany     Subject3    Maths   
  Erik    Strong  Sweden      Subject1    Chemistry   
  Erik    Strong  Sweden      Subject2    English 
  Erik    Strong  Sweden      Subject3    Biology 
  </code></pre>
  
  <p>Can anyone help please? Thank you!</p>