past rows into columns

[Guest]

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.

 

[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

 

[Niek Otten]

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

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

 

[Ron de Bruin]

Hi tkaplan

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