LinkBack URL
About LinkBacks
Hey pros, how do I transform thousands of groups of columns (each group has 6 columns) into A Single row (placed into another sheet) using Macro?
Since my data is large, so efficiency is also important.
Thanks very much.
transform.jpg
Hey pros, how do I transform thousands of groups of columns (each group has 6 columns) into A Single row (placed into another sheet) using Macro?
Since my data is large, so efficiency is also important.
Thanks very much.
transform.jpg
Looking for VBA solution or Formula solution?
In Formula solution the Formattings cannot be arrived
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
problem solved by myself. But thanks for your help.
Thanks, I am looking for VBA solution.
There are only 16384 columns.... do you have more than 2730 records? If you do, they won't fit.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are over 16384 cols, but I split them up several times. Thanks again, this problem is solved.
Originally Posted by newdoverman
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks