Hello,
I am trying to move data from column B into rows. In Column A, I have the corresponding Title to which the data in column B belongs to. However, I have over 10,000 lines. Is there any way to do this using VBA?
I have attached a spreadsheet as an example of what I am trying to accomplish.
Many thanks in advance and any advice is much appreciated.
Thanks!
Try:
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
If you're going where I think you're going, it wouldn't be hard to then delete columns B and C and then loop through and delete any rows where A is empty.
Thanks Solus. This is exactly what I needed!
No problem. If you are satisfied with the solution. Please mark the thread as [SOLVED]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks