From Columns to Rows

[Guest]

There are portions of a large spreadsheet--not the whole spreadsheet--where
I would like to convert several cells in one column to several cells in one
row. For example, I would like to easily cut D4, D5, D6, D7 and turn them
into E5, F5, G5, H5. Is there any way to do this without going one cell at a
time?


--Richard

 

[Larry S]

Select/Copy and then under EDIT, choose Paste Special an select the
TRANSPOSE option.

 

[Norman Jones]

Hi Richard,

Try:

Select the D47 range
Edit | Copy
Select E5
Edit | PasteSpecial | Transpose

 

[CaptainQuattro]

Copy the cells to the clipboard and then select Paste Special and check
Transpose.

 

[Guest]

You can select the cells in the column you want, copy them, and then select
the first destination cell in the row and paste special -> transpose.

Hope this helps,
Miguel