LinkBack URL
About LinkBacks
rsanguin 
You want 60,000 rows into ONE row?
Why?
Assuming you ONLY have three columns and 60,000 rows, you are going to need 180,000 columns, where Excel 2007+ only has 16,384 columns.
What are you trying to accomplish, as there is likely and easier way?
You want 60,000 rows into ONE row?
Why?
Assuming you ONLY have three columns and 60,000 rows, you are going to need 180,000 columns, where Excel 2007+ only has 16,384 columns.
What are you trying to accomplish, as there is likely and easier way?
Last edited by mikeTRON; 04-24-2015 at 02:07 PM.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
mikeTRON,
Sorry about it. I totally forgot to be more specific here.
I have a file with 60K+ rows which I need to arrange every 3 rows into a row, i.e.,
row1 1 2 3
row2 4 5 6
row3 7 8 9
row4 a b c
row5 d e f
row6 g h i
.....
After re-arranging them:
row1 2 3 4 5 6 7 8 9
row4 a b c d e f g h i
.....
It looks like easy but I do not know how to deal with it.
Thanks in advance...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks