Hi,
in office I have to work with a large number of data, which involves matching, transferring and consolidating data from one database to another. The tricky bit is that while in one database (DB1) there is a number of multiple single line elements (in column B) all sorted by a joint identifier (column A), the line elements need to be transferred to DB2 in a different manner.
DB2 contains a subset of the elements from column A (may be in a different order), and all elements from column B that have the same joint identifier shall be added to column B, but this time all within the same cell to the right of column A.
Example:
Example1.jpg
convert to
example2.jpg
Sample Database file (with both DB1 and DB2 sheet) is attached. Is there a smart and quick way to accomplish this using a macro?
Thanks for your help
Bookmarks