title: Power BI Convert Columns to Rows
body: <p>So I have an Excel file where the first column is a Donor and then there are pairs of columns for 10 years of Amount and Date as shown below:</p>
  
  <pre><code>Donor Name    2019 Amt  2019 Date 2018 Amt  2018 Date 2017 Amt  2017 Date
  ------------- -------- ---------- -------- ---------- -------- ----------
  Someone Here        50 08/21/2019
  Someone Else       150 06/15/2019       75 05/04/2018
  Another One                                                125 03/03/2017
  </code></pre>
  
  <p>And what I am looking for is:</p>
  
  <pre><code>Donor Name   Amount       Date
  ------------ ------ ----------
  Someone Here     50 08/21/2019
  Someone Else    150 06/15/2019
  Someone Else     75 05/04/2018
  Another One     125 03/03/2017
  </code></pre>
  
  <p>When I just unpivot the columns other than Donor name I get pairs of records for each entry.  It's closer to what I am looking for but not sure how to then transform that to the above.  Perhaps pivoting is not the answer?</p>