past rows into columns
 

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.

past rows into columns
 

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


"tkaplan" wrote in message
...
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.

past rows into columns
 

EditCopy
Select the start cell of
--
Kind regards,

Niek Otten
the destination area
EditPaste Special, check Transpose

"tkaplan" wrote in message
...
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.

past rows into columns
 

Hi tkaplan

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"tkaplan" wrote in message ...
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.