title: How to automatically nest rows of an Excel spreadsheet using level values?
body: <p>I am attempting to apply grouping to an Excel 2016 spreadsheet so that it can be more easily viewed and interpreted. The data in the spreadsheet is in a format similar to the following:</p>
  <pre><code>    A  B  C
  
  1   1  x  y
  
  2   1  x  z
  
  3   2  y  y
  
  4   2  x  z
  
  5   2  z  x
  
  6   1  x  y
  </code></pre>
  <p>Column A already contains the numbers corresponding to the nesting levels I want in my spreadsheet i.e. rows 3, 4 and 5 are &quot;children&quot; of row 2, so should be grouped together accordingly. The highest level reached in this particular spreadsheet is 5. I do not need to have any further interaction between rows in the spreadsheet, such as calculating subtotals. The spreadsheet is approximately 800 lines and a good solution will be used elsewhere, so doing this manually is not an ideal solution.</p>
  <p>How can I get the group function in Excel 2016 to recognise Column A as my grouping and apply the outline accordingly?</p>