Hi there,
I have a bunch of data that has been provided to me in a very difficult format to sort (for me at least).
I would like to convert an array into two columns, one for "X" and one for "Z". The data is arranged going from left to right, top to bottom with the appropriate X and Z data beside each other.
An excel spreadsheet is attached where I show what I would like the output to be (I can organize it with Brute force but I have to repeat this process many, many times!)
Thanks in advance
Maxim S
Try
Please Login or Register to view this content.
as an option
Please Login or Register to view this content.
Jindon- thanks for the input, but the code you posted as some glitches in it and I don't know VBA well enough to fix it
Nilem- your code almost works perfect; is there anyway to program it to add a break between each array? Each array has to be sorted largest-smallest in their own columns.
Thanks for the support!
Well I had this sitting on my PC while I went to a meeting so a may as well post it. Another way.
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Hey Guys,
Try my method too. I should have realized it had already been solved. Compare code??
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I don't understand what you mean.Originally Posted by Emou
Jindon- thanks for the input, but the code you posted as some glitches in it and I don't know VBA well enough to fix it
Try the attached.
another ertert
Wow! Thank you so much Nilem, that worked so well! :D
@ Emou
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks