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.

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.

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.

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.