Hi All,

I currently have an excel file which I need to re-format.  The fil
contains 18 columns as follows :

Prefix    Number    Service Date   Given Name  Surname   DOB   Panels1
Panels2    Panels3    Panels4
Panels5    Panels6    Panels7    Panels8    Panels9    Panels10    R$$ item    Value

The problem I have relates to the 10 columns which contain informatio
related to "Panels".  The original Panel data was contained in on
column ie:

Service date              Panel
May 97                      xxx, xxx, xxx, xxx

I have separated this data by using "text to columns", however, if th
service date column actually had four related panels as detailed belo

Service date               Panel
May 97                       xxx,  xxx, xxx, xxx

How do I relate this data on a separate line so that it reads as th
following example instead ?.

Service date               Panel
May 97                       xxx  
May 97                       xxx
May 97                       xxx
May 97                       xxx

Any assistance you could provide would be appreciated.  If you requir
any further information please email me.

Thanks and regards,

Damo  :confused