Forum menu
[Closed] Excel/Spreadsheet question - what to do with a lot of columns?
Topic starter
I've got a text file of data I need to get into escel. Problem is, it has 42,881 columns in it (and only 12 rows)
If I could transpose it, Excel would be fine, but I can't get it in in the first place as the max number of columns is 16,384.
Any suggestions how to do it?
I could regenerate the data in 3 seperate text files, but that will take days. 🙁
Posted : 11/05/2012 9:54 am
Copy, right click, paste special, check the "transpose" box.
Posted : 11/05/2012 9:56 am
Posted : 11/05/2012 9:56 am
Topic starter
problem with the direct transpose command is the data is too big to get in in the fiorst place.
Think I've found a solution in the text editor allowing me to block select...
Posted : 11/05/2012 10:05 am