First copy and stack the text in a column. Go to “express tools” and select convert text to mtext. now select all the text and click enter. All the texts are now a single entity and a multiitext.
Copy the text file and paste it in an excel sheet. The text will be in one cell and in a horizontal line.
This is how the text will appear when pasted in a excel sheet in order to arrange the text in separate rows ,go to DATA tab and click on TEXT TO COLUMNS icon and select DELIMITED option.
Tick on “Space” and then select next. Then finish
Now all text will be in separate horizontal cells (row)
Now in order to arrange the text in a column, select the entire row 1 and then select COPY.
Click on any other cell and then right click to select PASTE SPECIAL
In the dialogue box select TRANSPOSE as shown and then OK