moving alot of data (10000 cells) from a column to a row
 

I have an excel worksheet with 10000 bits of data in a column, i would like
to be able to move it into a row so that i can save the data as a *.CSV that
will seperate each cell by a comma insted of putting it onto a new line.

I have tried useing the copy, and paste special but i can't find away to
select 10000 cells in the first row, excel does not like it so it always says
it can not do it.

is there any easy way to goto the 10000 cell in the first row?? does excel
even allow that many cells in a row??

Please help, I have spent to long on this as it is.

Many Thanks

Paul

moving alot of data (10000 cells) from a column to a row
 

Paul,
A row can only have 256 cells (as there are 256 columns). This
changes in XL2007 (to I believe 16K).

"Paul Knight" wrote:

I have an excel worksheet with 10000 bits of data in a column, i would like
to be able to move it into a row so that i can save the data as a *.CSV that
will seperate each cell by a comma insted of putting it onto a new line.

I have tried useing the copy, and paste special but i can't find away to
select 10000 cells in the first row, excel does not like it so it always says
it can not do it.

is there any easy way to goto the 10000 cell in the first row?? does excel
even allow that many cells in a row??

Please help, I have spent to long on this as it is.

Many Thanks

Paul

moving alot of data (10000 cells) from a column to a row
 

Thanks Toppers, i'll try XL2007 as i'm running the office beta at work.

"Toppers" wrote:

Paul,
A row can only have 256 cells (as there are 256 columns). This
changes in XL2007 (to I believe 16K).

"Paul Knight" wrote:

I have an excel worksheet with 10000 bits of data in a column, i would like
to be able to move it into a row so that i can save the data as a *.CSV that
will seperate each cell by a comma insted of putting it onto a new line.

I have tried useing the copy, and paste special but i can't find away to
select 10000 cells in the first row, excel does not like it so it always says
it can not do it.

is there any easy way to goto the 10000 cell in the first row?? does excel
even allow that many cells in a row??

Please help, I have spent to long on this as it is.

Many Thanks

Paul

moving alot of data (10000 cells) from a column to a row
 

Thanks Toppers,

I sorted it by using Excel 2007 and it works great

Many thanks

"Paul Knight" wrote:

Thanks Toppers, i'll try XL2007 as i'm running the office beta at work.

"Toppers" wrote:

Paul,
A row can only have 256 cells (as there are 256 columns). This
changes in XL2007 (to I believe 16K).

"Paul Knight" wrote:

I have an excel worksheet with 10000 bits of data in a column, i would like
to be able to move it into a row so that i can save the data as a *.CSV that
will seperate each cell by a comma insted of putting it onto a new line.

I have tried useing the copy, and paste special but i can't find away to
select 10000 cells in the first row, excel does not like it so it always says
it can not do it.

is there any easy way to goto the 10000 cell in the first row?? does excel
even allow that many cells in a row??

Please help, I have spent to long on this as it is.

Many Thanks

Paul