Hi, please show your code and how it fails to do what you want, not just your input and desired output (although those are needed too), else it looks like you just want someone to do your homework for you.

In general, to build up a data structure like the one you need, you loop through the raw data and update a row in a table (using a Perl hash) by either pushing a value to a list, or incrementing a counter, contained at the key corresponding to the field in the data you are looking for.

Hope this helps!