Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Is there any way of putting the few rows I have in an Excel 2007 spreadsheet into one column instead?

a b c 
d e f 
g h i 



This is just a sample try out. I am working with large data set of 2000 values and want to know how I can convert the rows into a single column.

share|improve this question
What software are you using? – iglvzx Jun 15 '12 at 5:49
I can think of a rather involved way of doing it in excel (using indirect and offset) hoping someone else has a better way. How many rows are there? – soandos Jun 15 '12 at 5:50
@soandos If it is a text file, then you can use a programming language to iterate over each token (value of interest) and place them on their own line. – iglvzx Jun 15 '12 at 5:51
@iglvzx Right, but if it starts out as a non csv excel file, its harder – soandos Jun 15 '12 at 5:52
@cody_q, if you are using Excel as in your other question, which version of Excel are you using? – iglvzx Jun 15 '12 at 5:53

If you're using VI as text editor, you can easily do

:%s/ /\r/g

If you are willing to use sed, you can from the commandline in Linux type

sed 's/ /\n/g' filename
share|improve this answer

Making some assumptions here: It is excel, and the number of rows is small.

There are two steps here:

  1. Combine the rows into a single row (just put row 2 after the end of row 1, etc).
  2. Select all of row 2, and copy it. Right click in an unoccupied area, and select transpose (or paste special->transpose). Move it where-ever you want.

Note: the copy and paste areas for the transpose cannot overlap.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.