|Pathologically Eclectic Rubbish Lister|
Consolidating data from lots of different sourcesby blackadder (Hermit)
|on Jun 08, 2005 at 21:42 UTC||Need Help??|
blackadder has asked for the wisdom of the Perl Monks concerning the following question:
I wonder if you have a moment.
I have a data sheet containing the following column headers;
The data inside the table is of this nature;
And I need to consolidate the information pertaining to one entry in a single distinct record. Producing an output such as that;
And All the entries that were not matched with any thing will be stored else were. I have spend a lot of thinking time but haven’t managed to come up with any ideas.
Your divine intervention is highly regarded....Thanks.