Move data from column to row

  • Thread starter Thread starter The Doctor
  • Start date Start date
T

The Doctor

Hi All,

How can I move the data in column A (about 3000 entries) into Row 1??

I am sure it must be possible
 
Hi

Copy the cells. Select the first cell to paste to, then Edit/Paste Special
and check Transpose.

Andy.
 
There are only 256 columns, not enough room to move 3,000 entries into.
Theoretically speaking, if there was enough room one would use the TRANSPOSE
function, an array function which needs to be entered using shift+ctrl+enter
instead of just enter.

tim
 
The Doctor said:
Hi All,

How can I move the data in column A (about 3000 entries) into Row 1??

I am sure it must be possible
Click to expand...

There are only 256 columns, so you cannot put 3000 entries into one row.
For up to 256 cells, you can copy the cells from a column, select the first
cell in the row where you want them put, and use Edit > Paste Special >
Transpose.
 
Tim

Well spotted!! My error.

Andy.

Tim Otero said:
There are only 256 columns, not enough room to move 3,000 entries into.
Theoretically speaking, if there was enough room one would use the TRANSPOSE
function, an array function which needs to be entered using shift+ctrl+enter
instead of just enter.

tim
Click to expand...
 
Back
Top