title: Splitting an Excel spreadsheet into different worksheets based on column headers
body: <p>I have a spreadsheet with 45 columns. Some of the columns contain the same type of information, and I have grouped these columns together under a common column header.</p>
  
  <p>Please see the spreadsheet below for an example.</p>
  
  <p><a href="http://i.stack.imgur.com/8i9Rr.jpg" rel="nofollow">Spreadsheet</a></p>
  
  <p>With reference to the example above, I would like to split the spreadsheet into three different worksheets based on the top column headers (not values). Hence, there should be three worksheets called "Primary Info", "Secondary Info" and "More Info", in addition to the original worksheet which contains all the information.</p>
  
  <p>Under each of the new worksheets I want to see all the information related to that specific column header, e.g. the worksheet called "Primary Info" should display all fields for Name, Age and Gender. </p>