title: Excel 2013 - Group rows by column value
body: <p>How do I group rows by column value in Excel 2013, like how you see in a SharePoint list?</p>
  
  <p>For example, if this is my table:</p>
  
  <pre><code>Col 1 | Col 2 | Col 3 | Col 4
  -----------------------------
  1001  | 1002  | 1003  | 1004
  2001  | 2002  | 2003  | 1004
  3001  | 3002  | 3003  | 2004
  4001  | 4002  | 4003  | 2004
  </code></pre>
  
  <p>And I group by Col 4, I would like to see the result like this:</p>
  
  <pre><code>Col 4 = 1004
  
    Col 1 | Col 2 | Col 3 
    -----------------------
      1001  | 1002  | 1003
      2001  | 2002  | 2003
  
  Col 4 = 2004
  
    Col 1 | Col 2 | Col 3 
    -----------------------
      3001  | 3002  | 3003
      4001  | 4002  | 4003
  </code></pre>
  
  <p>Is this at all possible in Excel?  I tried creating a pivot table but it just creates nested rows, not the view I'm looking for.</p>
  
  <p>Anyone out there who can help?</p>