View Single Post
 
Old 09-11-2016, 05:22 AM
Tom Saylor Tom Saylor is offline Windows Vista Office 2007
Novice
 
Join Date: Sep 2016
Posts: 6
Tom Saylor is on a distinguished road
Default

It’s a long story, Graham. I work for a major educational testing company, developing all sorts of standardized tests, often consisting of multiple-choice questions (which we in the industry call “items”). For reasons all their own, a particular client wants batches of items delivered in an Excel sheet, one item per row. But the spreadsheet format (with items horizontally arrayed) is not at all congenial to the test development process. For that you need to have the items vertically arrayed in more or less the same way they’ll appear on the test and in a form that allows easy review and editing, and you want to have multiple items gathered into one document so that you can move readily from item to the next during the review process, resequence the items if necessary, and easily send all the items together from place to another. So for item development purposes, a Word file containing multiple items seems the most convenient option. The challenge I’m facing is to find the most convenient way to convert such a file to Excel format. You and others here have been a tremendous help. Thanks!
Reply With Quote