| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Data From One Column into Multiple Columns | Excel Worksheet Functions | |||
| Macro question | Excel Worksheet Functions | |||
| Otto M. - Data Matching | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Reference multiple cells in if statement | Excel Worksheet Functions | |||
Linear Mode
