how to move data down a column, and copy it into a row

[Guest]

I have data like this

dog
cats
birds
snakes

how can quickly move to a row like this

dog cats birds snakes

without having to use copy and paste for each cell


Torres

 

[Guest]

Hi
Have a look at the TRANSPOSE function
In your case it might be =TRANSPOSE($A$1:$A$4)

HTH
Michael Mitchelson

 

[Guest]

What I do is to:
1. copy your cells
2. Select the first cell of the row you want the data to start from
3. Edit > Paste Special > Check the "Transpose" box > Click "OK"

 

[David Biddulph]

I have data like this

dog
cats
birds
snakes

how can quickly move to a row like this

dog cats birds snakes

without having to use copy and paste for each cell

Copy, Paste Special, choose Transpose option.
Note that the paste area mustn't overlap with the area from which you're
copying.

 

[R.VENKATARAMAN]

in the paste area highlight only the first cell and then
pastespecial-transpose