past rows into columns

T

tkaplan

is there a way in excel that i can use to copy the values of a few rows into
columns.

for example:

a1: 1
a2: 2
a3: 3
a4: 4

copy a1:a4 and paste so that b1: 1, c1:2, d1: 3, e1:4

thanks in advance.
 
C

Chip Pearson

Copy the range, then select the first cell to paste into. Then,
go to the Edit menu, choose Paste Special, and check the
Transpose option.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
N

Niek Otten

Edit>Copy
Select the start cell of
--
Kind regards,

Niek Otten
the destination area
Edit>Paste Special, check Transpose
 
R

Ron de Bruin

Hi tkaplan

Select A1:A4
Copy
Right click on B1 and choose Paste Special
Transpose
OK
 
Top