title: Can handontable pivot data
body: <p>Handsontable really fits my needs when it comes to UI interaction. But was wondering if it can also pivot data.</p>
  
  <p>I have Json data that looks like this:</p>
  
  <pre><code>var objectData = [
    {id: 1, name: "Ted Right", gender: "male"},
    {id: 2, name: "Bill Allan", gender: "male"},
    {id: 1, name: "Joan Well", gender: "female"},  
    {id: 2, name: "Jane Doe", gender: "female"}
  ];
  </code></pre>
  
  <p>where id value should be the row name and the gender value should be the column header and the name is the value in the table.</p>