title: Change a flat table to a PivotTable/crosstab that shows TEXT results instead of calculations
body: <p>I have a large file of survey-type information that I would like to change the format of: from a flat table to a crosstab. PivotTables don't appear to be what I want for this purpose because each response is unique text, so I couldn't assign a numeric value to the responses and then convert that using a formula once in the PivotTable.</p>
  
  <p>This is the format that I have versus the format that I want: <a href="http://imgur.com/qLjp4v2" rel="nofollow">http://imgur.com/qLjp4v2</a> </p>