I need to generate a report that looks like this

We will happily help you to learn Perl, and answer specific questions when you get stuck, but if you want somebody to do your work or homework for you, please post at http://jobs.perl.org/ or http://www.rentacoder.com/ or so.

So please show some effort, show us what you've done, and where you are facing problems.

You've been posting here since 2003, you should know better than to simply post example input, your desired output and expect people to do your work for you.

Update: See post prior to update by OP for context.

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.

Is it possible to do this task using the format statement or is there a Perl module suitable for it?

As for the modules, you might get better responses by formulating the question like this: I have searched CPAN for modules helping with building up reports. Does anyone have experienced with such CPAN modules, and can recommend me some?. This would make more sense, because although there is plenty of stuff on CPAN, the quality of the modules varies a lot, and a personal recommendation would help choosing one over the other...

And finally (Assuming that you added the part saying I am not asking anyone to do my homework,... as an update): If you update your posting - and this is especially true if it is a not so small posting (you could have expressed the same in about 10% of the size!) - , I strongly recommend to mark the updated part in a way that it makes it easier to see.

Assuming that you added the part saying I am not asking anyone to do my homework,... as an update

only the ill-intentioned will not take that for granted

We aren't here to do homework for you.We are here to help you.If you face some problem,specify where in your code.You first post your code and tell us where you have problem.