+ Reply to Thread
Results 1 to 4 of 4

Transfer and consolidate data from multiple line items to within single cell

  1. #1
    Registered User
    Join Date
    09-18-2014
    Location
    Manila, Philippines
    MS-Off Ver
    Office 2016 for Windows
    Posts
    14

    Transfer and consolidate data from multiple line items to within single cell

    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
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: Transfer and consolidate data from multiple line items to within single cell

    See if this is what you wanted.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-18-2014
    Location
    Manila, Philippines
    MS-Off Ver
    Office 2016 for Windows
    Posts
    14

    Re: Transfer and consolidate data from multiple line items to within single cell

    Thanks a lot Jindon. This seems to do the trick. I will do more testing next week when back in office.

    Just a question though. The object "scripting.dictionary" does not work when I initially tested on Mac Excel, at least not on my Mac. Does it work for every Excel version for Windows? Would there be a way without using this object to make the macro more universal?

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: Transfer and consolidate data from multiple line items to within single cell

    This should work on any Excel.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Consolidate data from multiple excel files into single file
    By hkkk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2013, 03:34 AM
  2. Replies: 0
    Last Post: 06-29-2012, 03:16 PM
  3. consolidate data from multiple workbooks to a single worksheet
    By vbadummy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2010, 02:42 PM
  4. Replies: 2
    Last Post: 05-11-2010, 09:36 AM
  5. Link Word Multiple Line Data into Excel Single Cell
    By mohanvamsi_18 in forum Excel General
    Replies: 0
    Last Post: 01-21-2010, 03:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1