MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Chat Forum
3
Posts
3
Users
0
Reactions
61
Views
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 8:54 am
Copy, right click, paste special, check the "transpose" box.
Posted : 11/05/2012 8:56 am
Posted : 11/05/2012 8: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 9:05 am