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 have a column in excel suppose

12
13
12
12
34

I want to change it in row like

2 13 12 12 34

I tried to tranpose it but All the changed data go in single cell. I need to copy column and dump it in row each cell one value

share|improve this question
    
how did you try to transpose it? – mcalex Feb 18 '13 at 9:05
  1. Choose the appropriate column.
  2. Copy.
  3. Choose the first cell of tow.
  4. Right mouse button - Paste Special - mark the transpose checkbox.
  5. Ok.

The result is a inserted column in a row.

share|improve this answer

You must log in to answer this question.

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