Basically, I'm trying to enter data from surveymonkey, but there are too many columns to fit into 1 sheet, so surveymonkey splits it into 2. Obviously, this is no good as it splits all my data into two, and there are no more columns left to paster it together.
Ultimately, I'm only doing this to format the data before exporting it to SPSS - don't know whether this might help you give me an answer?
Any support much appreciated!!!!
THANK YOU!!
2007-07-03 04:04:33 · 7 answers · asked by scottgray 2 in Computers & Internet ➔ Software
There is too much data to transpose it the other way too!!!
2007-07-03 04:30:21 · update #1
There is a limit on the number of columns you can have in an Excel Spreadsheet. Once you have used all the columns (or all the rows) there is no way to add more.
2007-07-03 04:08:32 · answer #1 · answered by dewcoons 7 · 0⤊ 0⤋
The column limit in excel is 255. If you're exceeding this, I would look into transposing the data, so that what normally would be columns gets put into rows, and normal rows get put into columns. You can do this with the 'paste special' option.
2007-07-03 11:09:55 · answer #2 · answered by Snoopy 5 · 0⤊ 0⤋
Excel is not a database...it is to make spreadsheets. So, you need to move this over to Access. Access makes it easy to import Excel. There will be a little learning curve with it, but Access is easy to use and widely supported. You'll also find after you've learned it, that there is many powerful ways to manipulate the data. Bottom line: you need to move it out of Excel. Large Excel spreadsheets corrupt easily. You stand a good chance of losing your data.
If you didn't pay the bucks to Micro$oft for Access, consider downloading the Micro$oft SQL Desktop Express Edition. It is free. There is a bigger learning curve with it, but it is fairly powerful for a free product. Another free product is MySQL.
2007-07-03 11:14:27 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Excel 2003 Worksheet maximum size
65,536 rows by 256 columns
2007-07-03 11:11:30 · answer #4 · answered by Catherine 4 · 0⤊ 0⤋
Get Excel 2007, the spreadsheet is much much larger than the older versions. Although it may not be worth the expense if you only need Excel to do some exporting.
2007-07-03 11:12:07 · answer #5 · answered by Mary Laurita 3 · 0⤊ 0⤋
Consider interchanging rows and columns. Excel will happily support many rows.
2007-07-03 11:12:48 · answer #6 · answered by Anonymous · 0⤊ 0⤋
You can have more rows than columns. Can you reorient the data to switch rows and columns?
2007-07-03 11:10:17 · answer #7 · answered by Barkley Hound 7 · 0⤊ 0⤋