Copy columns into rows

S

ss

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

RagDyer

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

--

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top