Thanks for taking the time to think this through, Graham. Even if it's not what I'd hoped to hear, it's helpful to find out what is and and isn't feasible from someone who knows the terrain.

The Word files I'm working with often contain as many as 50 data sets (multiple-choices questions), so manual division would be cumbersome. I believe there's a Word macro available that will divide a large file into 50 smaller files according to delimiters placed in the large file, so maybe I could use that and then run Edstein's Excel macro, targeting the folder containing the 50 smaller files.

I'm intrigued, though, by your other suggestion that I might divide a long row of Excel data into multiple smaller segments. In my case, this would mean transforming a single 700-column row into 50 vertically aligned 14-column rows. Is there an Excel function or macro that would allow me to do this automatically?