title: Transposing Rows to Columns
body: <p>I am trying to come up with a single result set from two tables in a way that I have never done, and I am having a little bit of trouble figuring out how to do it or even what to search for in these forums. Consider the following hypothetical table data:        </p>
  
  <pre><code>Table1
  ----------------------------------
  ID  |  Name
  ----------------------------------
  1   |  aa
  2   |  bb
  3   |  cc
  4   |  dd
  5   |  ee
  
  
  Table2
  ----------------------------------
  ID  |  Table1_ID  |  Value
  ----------------------------------
  1   |  1          |  good
  2   |  2          |  Dumb
  3   |  3          |  Fat
  4   |  4          |  Wet
  5   |  5          |  High
  6   |  1          |  Thin
  7   |  2          |  Tall
  8   |  3          |  Goofy
  9   |  4          |  Rich
  10  |  5          |  Funny
  </code></pre>
  
  <p>I am looking for a query or method that allows me to end up with the following result set:
  Code:</p>
  
  <pre><code>aa      |    bb     |    cc       |    dd      |    ee
  ---------------------------------------------------------------
  good     |    Dumb   |    Fat     |    Wet     |    High
  Thin     |    Tall   |    Goofy   |    Rich    |    Funny
  </code></pre>
  
  <p>Essentially, I want the ability to take the list of names from Table1, transpose them into column headers, then put all of Table2's values into their respective columns with the ability to sort on any column. Is this possible?</p>