title: Pivoting a Table with Text and no Aggregation
body: <p>I've been looking through StackOverflow questions and haven't really found one for this issue. </p>
  
  <p>I have a table that's arranged basically like:</p>
  
  <pre><code>Table.LineID
  Table.QuestionGroup
  Table.Question
  Table.Answer
  </code></pre>
  
  <p>And I'd like to "pivot" the table, but the questions and answers don't have anything to aggregate. They're all just text fields for example, one might read:</p>
  
  <pre><code>Table.LineID = 00001
  Table.QuestionGroup = Color
  Table.Question = Outside Color
  Table.Answer = Dark Green
  
  Table.LineID = 00001
  Table.QuestionGroup = Size
  Table.Question = Height
  Table.Answer = 180 3/4
  </code></pre>
  
  <p>I'm trying to pivot the table so that I can get the associated ID of line and make that the spreading function the Questions So it would look like</p>
  
  <p>LineID | Question 1 | Question 2 | Etc...</p>
  
  | Answer 1   |  Answer 2  | Etc...
  
  <p>I've looked at this <a href="https://stackoverflow.com/a/7744347/839330">https://stackoverflow.com/a/7744347/839330</a> except this seems to be more in reference to some VB code (maybe I'm wrong?). Does anyone have an idea on how I should approach this? </p>