title: How to "pivot" data with unequal resulting columns using Power Query
body: <p>I am struggling to convert some data.  I want to go from this:</p>
  
  <pre><code>Faculty, Course
  Jane Doe, BW 401-01
  Jane Doe, BW 402-01
  John Doe, BW 101-01
  John Doe, BW 101-02
  John Doe, BW 103-01
  </code></pre>
  
  <p>To this:</p>
  
  <pre><code>Faculty, Course01, Course02, Course03
  Jane Doe, BW 401-01, BW 402-01,
  John Doe, BW 101-01, BW 101-02, BW 103-01
  </code></pre>
  
  <p>The data could have any number of faculty and any number of courses. 
  I have tried playing with Pivot and UnPivot but neither do what I want. Any ideas of how I would approach this in Power Query? </p>
  
  <p>Any ideas are greatly appreciated!</p>