I need help with this. I have data in ColA that is separated by a blank cell. The data is never the same number of rows so the only constant is the empty rows between the data. I need to transpose that data over and over again into ColB all the way till there is no more data. Here is a sample of my data:
ColA
data
data
data
data
data
data
data
data
data
etc.
I want the result to look similar to this:
ColB ColC ColD ColE
data data data
data data data data
data data
etc
Last edited by PY_; 09-06-2013 at 06:23 AM.
Try:
Please Login or Register to view this content.
Last edited by stnkynts; 09-05-2013 at 11:24 PM.
Hi,
Try this... it may not be the most elegant solution but it seems to work :
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Please Login or Register to view this content.
Thank you all for the help! Every solution provided worked as desired.
I ended up using jindon's solution simply because it ran very fast. I have a ton of data and the other two macros did take quite a bit of time to run.
Even though jindon's solution is the fastest and it does work great, it still takes almost 2 minutes to run on a decent computer with the data i have. Is there perhaps another way of doing it?
Things i turn off before running the script: calculation, screenupdating, events
Try this one
Please Login or Register to view this content.
Wow, big thanks!
I ran the two scripts on my home laptop (not as powerful as work). I added a timer to each for comparison.
The old script : 240 seconds
The new script: 0.18 seconds.
I think ill use the new one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks