Pivot table menu

If I understand correctly then perhaps the attached pivot table (sheet PT) is what you want.
To produce the pivot table select one of the cells in the range A1:T161 on the stock sheet,
Select the Insert tab,
Select Pivot Table, (you may have to correct the range as it originally displayed A1:T1001)
Select OK.
From the pivot table field list drag fields down to the row labels window as in the attachment (enable editing to see the field list)
Next drag the fields into the values window (you may have to change the field values of some fields from count to sum and visa versa as shown)
Note that to get the count column I dragged the Roll No. field into the values window and manually changed cell B3 so that it displayed 'Count ' (space added)
You may wish to turn off subtotals (as was done for the attachment) and/or grand totals.
Let us know if you have any questions.