Hello all, I am new here so I hope i do this in the correct forum.
I have an excel user who each week receives an EDI transfer of orders from one, two or three different companies. Each EDI may have one, two or all three depending. THere are only three companies ever.
The problem that I have is that the data is formatted so crazily that I need some major clean up module before I can import it into a database to work with the data. I am not even sure VB can do it. I have attached an example of the raw data and an example of the ideal data. The data always appears like this so one instance would work ongoing.
Essentially what I need to do is eliminate the crap rows of junk data and assign the company name and the "for" date to each part ordered so that the data would look like this
Company Name Date Needed Model Part
Company 1 7/10/2006 blah blah
Company 2 7/10/2006 blah blah
Company 3 7/10/2006 blah blah
Company 3 7/10/2006 blah blah
What you will see in the attachment is that the company name and date needed are listed in columns above all of the data that corresponds. Below the company in the same column can be either a number or the word "for" or "line" for some reason. I need to somehow take the company name and move it left and fill it down for the corresponding data (sheet two of the attachment shows how it would ideally look.)
If anyone can give me some direction with this I would be most appreciative or if you could direct me to something to read on this. ANYTHING closer would be greatly appreciated as well. ... Thank you in advance.
Reply With Quote