Re-organising a table of data ?

I have a table of data that I need to re-organise. It seems simple in theory but trying to convert the concept has been a big struggle! I have been trying pivot-tables, vlookups, matches, lookups, but without getting even close!

I would like the final result to summarise the data into just one row per RFI number eg
RFI-000008 Re: Dimension Check - Turner 2/5/07 - Davidson 3/5/07 - Marina 3/5/07 - Aru 4/5/07 - Aru 8/5/07
RFI-000007 etc etc

This is the core data ...

RFI*SUBJECT*Date*ORG
RFI-000008*Re:Dimension Check*2/5/2007*Turner
RFI-000008*Re:Dimension Check*3/5/2007*Davidson
RFI-000008*Re:Dimension Check*3/5/2007*Marine
RFI-000008*Re:Dimension Check*8/5/2007*Aru
RFI-000008*Re:Dimension Check*4/5/2007*Aru
RFI-000007*Re:Beam Size Confirm*4/5/2007*Sampter
RFI-000007*Re:Beam Size Confirm*4/5/2007*Marine
RFI-000007*Re:Beam Size Confirm*5/5/2007*Aru
RFI-000007*Re:Beam Size Confirm*7/5/2007*Davidson

Would be awesome if anyone can provide a few leads to try and help me get started.

It is in columns ... but I need to work out how to translate & group it into the above format.