title: Transpose columns into new column and maintain/duplicate rows accordingly
body: <p>Apologies for awkward title. I have searched through the forums but not yet come across a solution which is appropriate. I imagine what I am after will require the use of a macro.</p>
  
  <p>I have a spreadsheet which outlines transactions by row, that is, one row for each transaction. Each transaction contains projected financial data. So, each row relates to one transaction which has financial impacts across multiple years.</p>
  
  <p>For example, the header looks like</p>
  
  <pre><code>Transaction | field1 | field 2 | etc. | 2010-11 | 2011-12 | 2012-13 | etc. |
  </code></pre>
  
  <p>Beneath the years are dollar amounts.</p>
  
  <p>All the fields contain data I need replicated across rows, except I want the <strong>year</strong> transposed into a single column, with the financials against it.</p>
  
  <p>So if I have the record:</p>
  
  <pre><code>exampleid | data | data | 45000 | 56000 | 223145 | data
  </code></pre>
  
  <p>I would like it too become:</p>
  
  <pre><code>exampleid | data | data | 2010/11 | 45000  | data
  exampleid | data | data | 2011/12 | 56000  | data
  exampleid | data | data | 2012/13 | 223145 | data
  </code></pre>
  
  <p>There are around 30 columns.</p>