title: Make chart or table based on grouping url parameters values in excel
body: <p>Let's say I have a bunch of urls like so:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>URL</th>
  <th>views</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>blah/?color=green&amp;size=l</td>
  <td>50</td>
  </tr>
  <tr>
  <td>blah/?color=green&amp;size=s</td>
  <td>50</td>
  </tr>
  <tr>
  <td>blah/?color=red&amp;size=l</td>
  <td>87</td>
  </tr>
  <tr>
  <td>blah/?color=green&amp;size=m</td>
  <td>60</td>
  </tr>
  <tr>
  <td>blah/?color=yellow&amp;size=l</td>
  <td>32</td>
  </tr>
  <tr>
  <td>blah/?color=green&amp;size=m</td>
  <td>10</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to make a chart/pivot table or anything possible that will group by text (here, by the value of the color parameter) and show the sum of this group.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>URL</th>
  <th>views</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>green</td>
  <td>170</td>
  </tr>
  <tr>
  <td>red</td>
  <td>87</td>
  </tr>
  <tr>
  <td>yellow</td>
  <td>32</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>How can I do such a thing?</p>