This solution is a bit long winded but it works
What we want to do is to normalize the data you provided
Add a column before your data (sheet1) and let's call it Line (or anything you want)
Enter a name for each row ( say L1 and pull down)
Now press Alt+D then P - you get the 2003 Pivot Table wizard
Check "Multiple consolidation ranges"
Next
Check "I will create..."
Next
Select the range ( in our casee A2:E9)
Click "Add"
Next
Select where you want the result
Finish
You now have a Pivot Table which IS NOT THE ONE YOU WANTED
Still some work to do..
From the PT Field list, drag the row and column tab off the grid ( or uncheck them)
You are now left with two cells
One containing "Count of Value" ( or another function) and another with a number (19 in your example)
Double click the 19 and in a new sheet (sheet4) appears your normalized list
Starting from there you can apply the usual PT techniques after providing for row and column headings eventually.