transpose

karraj · Mar 12th, 2002, 02:19 PM

I have two ranges a2:a25 and b1:z1 I want cell b1 =a2 and c1 =a3 and so on.
Is there any short way to do this!

Russell Hauf · Mar 12th, 2002, 02:21 PM

Quote:

On 2002-03-12 13:19, karraj wrote:
I have two ranges a2:a25 and b1:z1 I want cell b1 =a2 and c1 =a3 and so on.
Is there any short way to do this!

You can copy, then paste special, transpose.

Or, you could select b1:z1 (yes, the whole range), and type in the following formula:

=TRANSPOSE(A2:A25)

and before you press enter, type Ctrl+Shift+Enter instead (this is an array formula).

Hope this helps,

Russell

cilla4991 · Mar 27th, 2002, 02:58 PM

Russell,

THANK YOU VERY MUCH.

I was wondering the same thing and have been trying to figure this function out for the past hour. Excel's Help does a POOR job of explaining how to use this function (they missed the CTRL+SHIFT+ENTER part).

Priscilla

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 02:19 PM	#1
karraj Board Regular Join Date: Mar 2002 Posts: 76	I have two ranges a2:a25 and b1:z1 I want cell b1 =a2 and c1 =a3 and so on. Is there any short way to do this!

Mar 27th, 2002, 02:58 PM	#3
cilla4991 New Member Join Date: Mar 2002 Posts: 1	Russell, THANK YOU VERY MUCH. I was wondering the same thing and have been trying to figure this function out for the past hour. Excel's Help does a POOR job of explaining how to use this function (they missed the CTRL+SHIFT+ENTER part). Priscilla