I've seen your post and read some of the comments to it. Basically this is a forum about Perl programming. I don't see any Perl programming question in your post.

I am a tutor at a local college and I spent about 5 hours yesterday doing that. I didn't have any Perl questions, but I did have a lot of C questions. One class is working on a hash table of pointers to linked lists, one class is working on a doubly linked list assignment, one class is working on a graph assignment and there are some intermediate assignments in progress.

The most clueless Newbie that I talked with was taking an unimaginably easy beginning C class, had never taken a programming class in his life, but this guy had 4 lines of working code and was unsure about how to make it do X. My point is that I have just as much time for this newbie as I do for the advanced C students because this student was actually trying and was doing something!

You will get enormous help here if you do something! That means write some code and take a stab at it. If its not perfect, that's fine, that's why you are asking for help!

To generate the report that you want is easy in Excel. I imported your data into Excel as a "sanity check" and I see that the "Tessa" line is malformed. Why are you posting test data like that here?

From what I see, save yourself a lot of grief and anguish and learn how to use Excel.