Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to move the entire content of an MS Word file into a table.

The content consists of Objective Questions like:

  1. Question 1

    a. option1   b. option2   c. option3   d. option4

  2. Question 2

    a. option1   b. option2   c. option3   d. option4

... and so on.

I was looking for it to get converted into a single-column table like this:

|1.Question 1 Description               |
|a)option1      b)option2               |
|c)option3      d)option4               |
|2.Question 2 Descripton                |
|a)option1      b)option2               |
|c)option3      d)option4               |

... and so on.

I tried using the "Convert text to table" option, but was not able to achieve this.

How can I do so?

share|improve this question
Just saying, like this, but Excel should have much more advanced options such as this. – Ariane Feb 20 '13 at 12:46
Do you need to do this ONCE for a lot of data, or on a regular basis. – Robert Ilbrink Feb 21 '13 at 10:08
@Nishant Kashyap, There are two people who provided you with an answer. We have not received any feedback from you so far. Please indicate what was helpful or what would be missing. If one of the answers was helpful, then please "Accept" that answer by clicking on the white check-mark to turn it green. Thank you! – Robert Ilbrink Feb 23 '13 at 9:37
@Nishant Kashyap, any feedback on what has worked for you? – Robert Ilbrink Feb 28 '13 at 13:13

This will achieve what you are looking for in Word, according to the details you've given. I do not use Open Office, but I would imagine you could do similar.

Create a single column table, above or below the questions, with the appropriate number of rows you need. Then highlight each question and drag it to the row you want it in. You may need to put a carriage return after b)option2 in order to get options c & d below a & b.

enter image description here

share|improve this answer

If you know how to get the Questions in one column (e.g. add one extra column in A with sequence numbers, sort the data in Column B , split the blocks starting with Question... and the block starting with a. option1, move the a. options block to column C, remove the block with "empty" lines, then re-sort based on the sequence numbers in Column A and remove the first cell in Column C) to allign the questions and answers, then in Column D you add the formula: =B1&CHAR(10)&C1 and copy down, then do a copy/paste special Text (only) in column D to "fix" the formula into text.

One more addition, I overlooked the split of the options into two rows as well. Here you could do the following (again if this needs to be done only once, otherwise you could write a script). Highlight Column C (answers) and replace (Use the: selected area only option) Spacec.Space with $Spacec.Space. Then do a text to columns on Column C, using the $ as a separator. You now have Answers a & b in column C and answers d & d in column D. Then use the formula =B1&CHAR(10)&C1&CHAR(10)&D1 in Column E.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .