How can I move data from more than one row down, to many colums .

[Guest]

Can rows be moved to colums accross without dragging and dropping?

 

[Frank Kabel]

Hi
not really sure what you're trying to do. Could you give an example?

 

[Myrna Larson]

If you mean transpose, I don't think you can do that with the mouse.
Edit/Copy, then Edit/Paste Special and select the Tranpose option.

 

[mzehr]

Hi Randy,
Without having more information, it sounds like you are
wanting to convert, for instance, one column of data with
multiple rows into several rows spread out over several
columns. If so check out the following website:
http://www.mvps.org/dmcritchie/excel/snakecol.htm

 

[Gord Dibben]

You can use the TRANSPOSE Function and never touch a mouse.

See help on TRANSPOSE.

Remember to select the appropriate number of columns before entering the
Function formula.

Also, it is an Array formula and must be entered using CRTL + SHIFT + ENTER.

Gord Dibben Excel MVP