I have a download from our ERP system. It contains 11 fields. the 11th field, is a note/memo field that can contain up to XX number of unique order identifiers. In this field each unique identifier is separated by a space.
I need to parse each unique identifier into it's own ROW. I have attached a file as an example. Any suggestions?
First the regular text to column on column K and after that I run this macro.
I made some more headers to include all data.
There are people who can make a more neat version, but this one works, I tested it.
See the attached file.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi RDE,
Another Option:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Yet, another one
the last two are very nice solutions, but they do not copy the first 10 columns data when they parse column K. I need column A - J repeated for the parsing process. I will see if I can modify one of these macro's, if not the first solution does repeat column A - J. So in the meantime I can use it.
Are you sure you have checked my code? The output is on desired data
AN EASY FIX:
Please Login or Register to view this content.
Late to the party, as ever, but I was having so much fun working on this so I thought I'd share. A couple of variations on a theme. The first outputs the parsed data row by row, whereas the second outputs blocks of data for each input row.
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
yes thanks everyone, the solutions did copy the information Not sure what I did wrong.
One issue, in my first example I never showed column K with a single ELAxxxxx item so when the above macro hits say cell K35 and it only has one value in column K it errors out. Not a big deal I just sorted the multiple value rows to the top and it worked great. Again many thanks to everyone.
Both the solutions shown in Post #8 worked with a single entry in column K. I added a row of data to specifically test that condition.
Whatever ...
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
I fixed my code for the one ELA value in Column K:
Please Login or Register to view this content.
sorry I had not tested post 8 yet. I had to get the project done, so I had just come back to this. I have to do some work this weekend, but will test late sunday or first thing Monday morning.
I just read your post in detail, I will mark the post completed, and do the thank you as you noted. thank you for the detailed instructions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks