title: Group data based on count of duplicate values in a certain column
body: <p>I have an excel sheet that is organized as follows:</p>
  
  <pre><code>COL1   COL2
  1      30   
  2      30
  3      29 
  4      12
  5      12
  6      12
  </code></pre>
  
  <p>In the above, as you can see, values are being repeated in COL2. I need to group these values count and then place them in separate workbooks. So, for example, the output should be</p>
  
  <pre><code>Total Records: 2
  1, 30, ......
  2, 30, ......
  
  Total Records: 1
  3, 29, ......
  
  Total Records: 3
  4, 12, ......
  5, 12, ......
  6, 12, ......
  </code></pre>
  
  <p>Once that is calculate, I need them exported into separate excel sheets. </p>
  
  <p>Can someone please help me figure out the best approach to do this? How may this be done in Excel?</p>