I have a database with the following structure:
Headword in a foreign language followed by frequency (delimited with comma) and eventually followed by a list of glosses in English, each gloss delimited with a comma. A small sample is given below
I need a script or a macro to convert these into the following format. The first item from the example is given as a converted item.
The macro I have written is too slow and takes a large amount of time. Basically the macro selects the headword. Pastes it onto a next line, chooses the first gloss (deletes it), pastes it onto the headword on line 2, preceded by an equal to sign and carries on till all the glosses on a line are exhausted. The process is repeated till all the headwords are exhausted.
The macro takes ages , since the glosses for a single headword are considerable and also because there are a large number of headwords.
Any way of speeding the process up would be gratefully acknowledged.