Copy columns into rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ss - 22 Sep 2004 19:08 GMT

Can anyone advise me how to copy columns of contiguous
cells, into a much easier to read row of contiguous cells?

Reply to this Message

- 22 Sep 2004 19:16 GMT

hi,
copy the column. select a cell in column a.
goto edit>paste special>transpose

>-----Original Message-----
>Can anyone advise me how to copy columns of contiguous
>cells, into a much easier to read row of contiguous cells?
>.

Reply to this Message

RagDyer - 22 Sep 2004 19:19 GMT

Don't forget, only 256 columns, which means only that many rows can be moved
to a *single* row.

Select the column(s),
Right click in the selection and choose "Copy".
Right click in the first cell of the row to receive the data,
Then choose "PasteSpecial".
Make sure there's no overlap of the original data.
Click on "Transpose", then <OK>.

Signature

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Can anyone advise me how to copy columns of contiguous
cells, into a much easier to read row of contiguous cells?

Reply to this Message

ss - 22 Sep 2004 20:18 GMT

much thanks

>-----Original Message-----
>Don't forget, only 256 columns, which means only that many rows can be moved
[quoted text clipped - 11 lines]
>
>.

Reply to this Message