From Columns to Rows

[Richard]

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

[CaptainQuattro]

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

[Larry S]

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

"Richard" <[email protected]> wrote in message
news:[email protected]...
>
> 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

[Norman Jones]

Hi Richard,

Try:

Select the D4:D7 range
Edit | Copy
Select E5
Edit | PasteSpecial | Transpose


---
Regards,
Norman



"Richard" <[email protected]> wrote in message
news:[email protected]...
>
> 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

[Miguel Zapico]

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

"Richard" wrote:

>
> 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