Greetings, I am working with a very large spreadsheet (600,000+ rows), and I really only have 2 problems We pulled the data from one system and need to upload into another. I am going to show some example rows with some data omitted. All data exists in Column A (I'll parse it up later):
Problem1 -
1 | |700 |061A7350807EC04AE1000000AC167310|20121009014239 |EXTENDED MATERIAL DESCRIPTION |14M |E_GTS_EXPMST|Part info for Justification10/9/2012 | | |
2 | |700 |0382DC4EBCDE8D38E1000000AC16728A|20120111143750 |WASHER,PROTECTION GP |D6K |SATCHGL |ECCN assigned per P.L. instructions to G.S. 22 Dec 11.
3 Classification Rationale is on file at Co.X, and is available upon request. Please contact the X Inc. Global Export Compl|iance Program Manage | |
As I said, all data exists in Column A. Row 1 is fine; row 2 is fine; but row 3 is actually a continuation of row 2, so I want to move its contents from Cell A3 and append it to the end of Cell A2 then delete row 3 - which doesn't seem to be too bad except for problem 2 below.
Problem 2, further down the same spreadsheet -
51 | |700 |0960944EEE5BB067E1000000AC16728A|20120323160535 |PANEL-CONTROL |C7.1 |OMANAM |This is a control panel used in an industrial engine.
52 Based on t|he information found it classifies as a programmable controler as the ones included in heading 8537.
53 This part was requested in a classification referral. Code approved by L.G. We are still waiting for deisgn control's response to confirm cod|e. |
In this case, BOTH 52 and 53 are continuing from 51, so I would want to append the contents of A53 to A52, then the new contents of A52 to A51 and delete rows 52 and 53.
I am not very good with macros, but I think I need one in this case. I would be happy even with multiple macros and/or formulas, and the pipes in my data don't bother me at all as they are easily removable.
Any help from anybody would earn my undying gratitude!
Doug
Bookmarks