past rows into columns

Posted to microsoft.public.excel.misc

tkaplan

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert columns to rows & rows to columns	ROCKWARRIOR	Excel Discussion (Misc queries)	2	September 23rd 05 06:31 PM
How to swap rows and columns?	[email protected]	Excel Discussion (Misc queries)	5	September 21st 05 08:07 AM
hidden rows & columns slow file open	Simon Shaw	Excel Discussion (Misc queries)	0	April 5th 05 12:21 AM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns	foofoo	Excel Discussion (Misc queries)	1	April 2nd 05 12:02 AM
Can I split my worksheet and have different size columns and rows.	tommy	Excel Discussion (Misc queries)	1	February 16th 05 11:17 PM

All times are GMT +1. The time now is 03:13 PM.

Menu

About Us