Need to create a concordance file from an Excel Worksheet

[gamouning]

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

 

[Otto Moehrbach]

Greg
What you say you have and what you say you want is not clear, at least
not to me. If you wish, send me a small file containing a few examples of
what you have as well as corresponding examples of what you want to have. A
before-and-after scenario. Also, what is a "concordance file"?
My email address is (e-mail address removed). Remove the "nop" from this
address. HTH Otto