Dear VBA experts,
I have a lengthy single column with data sets separated by empty cells like this:
275
284
288
286
269
232
215
201
186
146
132
112
How can I move each dataset to its own column so that it looks like:
275 232 146
284 215 132
288 201 112
286 186
269
I am new to VBA and have hunted around unsuccessfully for a way to do this. Thank you in advance for any help you can provide.
Hi _Raven_
Welcome to the forum...
Here's one way...
Please Login or Register to view this content.
Last edited by sintek; 07-12-2018 at 01:10 PM. Reason: Added snippet of code
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Try this code
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Thanks so much, sintek. This worked perfectly.
......................................
Thanks.gif
For the fun another way
Yes.... very similar to YasserKhalil 's one !!
Please Login or Register to view this content.
Last edited by PCI; 07-12-2018 at 03:32 PM.
- Battle without fear gives no glory - Just try
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks