Hi,

I need to create an alphabetical index for a directory using a
concordance file that is saved in an Excel Worksheet. Currently each
row contains a column for "number" and "additional terms" fields. Below
I have listed one example:

number = 396809    additional terms = Mind-Body Interaction,
Biopsychosoical Reserach, Children, Preoperative Interventions,
Alternative Medicine, Hypnosis, Acupuncture, Adults,

I need to transpose this excel file so that it appears as follows:

number = 396809    additional terms = Mind-Body Interaction
number = 396809    additional terms = Biopsychosoical Reserach
number = 396809    additional terms = Children
number = 396809    additional terms = Preoperative Interventions
number = 396809    additional terms = Alternative Medicine
number = 396809    additional terms = Hypnosis
number = 396809    additional terms = Acupuncture
number = 396809    additional terms = Adults

FYI, I have about 1000 records to process and not every records
contains data in the "additional terms" field. Any assistance you can
provide is greatly appreciated.

Regards,
Greg