parsing multiple records in one field to multiple fields

Hi,

I have a spreadsheet with Case_ID (column C) and Agent_Notes (Column S) columns.

The agent notes columns contain all notes from multiple interactions in a single cell, separated by predictable syntax (date and agent ID)

So in a given week, if more than one agent touches a case, the spreadsheet will show the new interaction record but using the same Case_ID from before (duplicate Column C case numbers) and the Agent_Notes will have all previous notes, with a new Notes record appended to the end of the cell value.

Is it possible to generate multiple rows from these single-cell, multi-agent records using the existing date/time agentID separator syntax and then as a second part of the operation, remove any duplicates at the end of the process where Case_ID and the new, separated agent notes match another row exactly?

This should eliminate any duplicate records where no new notes were written and leave only duplicate Case_IDs when the Agent_Notes field has different data.

Simply put, the records would show

Case_ID            Agent_Notes
1234                 Date/Time - AgentID - Notes, notes notes
1234                 Date/Time - AgentID - Notes, notes notes
1234                 Date/Time - AgentID - Notes, notes notes - Date2/Time2 AgentID2 More Notes

And the result of the operation in a new sheet would show:

Case_ID            Agent_Notes
1234                  Date/Time - AgentID - Notes, notes notes
1234                  Date2/Time2 - AgentID2 - More Notes

Here is the real syntax of a multi-interaction, single cell case note value:

Problem Description                                                                                                                 01.06.2008          11:50:27            BCHAKRABOR     eu says that he has virus in his pc...     tld eu has to clear off the hdd n reinstall the windows partition...     eu ready to run recovery....     initiated recovery frm f10....     did after recovery set up....     checked sound ...     checked internet...     everything is working     checked after restart....     issue resolved...rvc done by arvind...     closing case as per process....     ____________________     Problem Description     01.06.2008          10:43:24            NAGNIHOTRI     Csr- Cx calling for the same issue. Not able to do the system recovery     ____________________     Problem Description     01.06.2008          00:09:14            WAINSLEY     Issue: AV 2008... Malware!     Symptoms: Popups warning about infection.     Cause: malware     Environment: XP     CSO/ARM: N/A     ASG: No     Resolved: N/A     Functionality Proven: NO     How Issue Was Resolved: Refuse payment phone.     Reason For No Resolution: N/A     Refer To 3rd Party: N/A     Cust getting AV 2008 warnings popup IE windows for a few days.     Offered cust avail pay resources not interested.     Advised cust to Make a backup of data asap also sugested cust MAY try a     system restore from safe mode.     [REASON]:ZR02     [ACCESSORY]:     [Warranty information] ('yyyymmdd A' on accessory):     [Accessory replaced] y/n:     [Return kit sent] y/n:  


There are 3 records there:

01.06.2008          11:50:27            BCHAKRABOR
01.06.2008          10:43:24            NAGNIHOTRI  
01.06.2008          00:09:14            WAINSLEY

Are there a few lines of VBA to perform this operation?  Let me know if this is too complicated to ask here - I assume with my limited knowledge of Excel that I am asking for something pretty simple, but I don't know.

Thank you

Bill