Combine three databases into one in Excel

Posted on 2012-09-07
Last Modified: 2012-09-22

I've got three Excel spreadsheets (each from a different source) which I need to combine into a single spreadsheet. The data in the lists is from calls placed to members of an association sometime ago.

• List #1 contains 4097 unique member records (rows) each with nine columns (for demographic info, etc.). Some of the members included in the list were called once, some were called more than once and some not at all.

• List #2 contains 6680 records (each with seven columns) of the calls placed. Each call has a unique number (shown in gold in Fig. 1). The call records are tied to the member records by the name of the member (shown in yellow in Fig. 1).

Fig. 1• List #3 contains 3613 records, each with six fields (columns), documenting replies received following the calls.  The reply records do not include the member's name but do include the original call number from List #2 (shown in gold in Fig. 1).

What would be the best way to combine these three lists into a single spreadsheet so that each row represents a call and includes the member information and also the information for the reply to that call if it occurred?

Question by:Steve_Brady
    1 Comment
    LVL 9

    Accepted Solution

    In my opinion, for what you have described above the best way is to utilize MS Query to combine all 3 sources together (either using the excel sheets directly or directly from the sources if possible).

    You can generate an MS Query from inside an excel sheet by going to Data > From Other Sources > From Microsoft Query.

    There you get the option to query from Excel Sheets, MS Access Databases or your own defined data sources.

    I hope this helps.

    Good Luck!

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now