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

D

Dave T

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
 
M

Michael

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

HTH
Michael Mitchelson
 
M

Melissa

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"
 
D

David Biddulph

Dave T said:
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
Click to expand...

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