Hammertime
New Member
- Joined
- Feb 13, 2009
- Messages
- 4
Good afternoon!
Long time listener, first time caller...or something like that.
I have exported 2 CSV files from an oddball custom database, and cleaned up the data. There is a uniqueID (part#) between the 2 and aside from that all is different. What i'd like to do is find an easy way to create a 3rd worksheet, that will bring in the data from the first (26,000 lines by 18 columns) and append the data from the second (24,000 lines by 10 columns).
The ONLY common columns will be the PART#.
As you can see by the number of lines, some items are not listed in the second (making a simple copy and paste unusable).
Also, if there IS an item in the second that is NOT listed in the first, then a new line will need to created, with ONLY the applicable info populated into it.
i have attached 3 images to demo the bulk of what i am thinking...
and the finished product:
any help or suggestions would be HUGELY appreciated.
thanks!
Damien
Long time listener, first time caller...or something like that.
I have exported 2 CSV files from an oddball custom database, and cleaned up the data. There is a uniqueID (part#) between the 2 and aside from that all is different. What i'd like to do is find an easy way to create a 3rd worksheet, that will bring in the data from the first (26,000 lines by 18 columns) and append the data from the second (24,000 lines by 10 columns).
The ONLY common columns will be the PART#.
As you can see by the number of lines, some items are not listed in the second (making a simple copy and paste unusable).
Also, if there IS an item in the second that is NOT listed in the first, then a new line will need to created, with ONLY the applicable info populated into it.
i have attached 3 images to demo the bulk of what i am thinking...
and the finished product:
any help or suggestions would be HUGELY appreciated.
thanks!
Damien