+ Reply to Thread
Results 1 to 5 of 5

Merge two sheets but matching numbers?

  1. #1
    Registered User
    Join Date
    01-03-2021
    Location
    Indiana
    MS-Off Ver
    365
    Posts
    31

    Merge two sheets but matching numbers?

    Hi, I have two excel sheets. I need to merge, combine or sync them. Some of the column headers have the same name.

    For example,
    Sheet one has column headers: job number, job name, job ID
    Sheet two has column headers: job number, job category.

    Attached are sample sheets with made-up information but it shows what I need to do.

    I need these two sheets to become one sheet. Sheet 1 and sheet 2 job numbers need to match us and place the job category in the correct row to match the job number.

    Any idea how to do this?
    Thank you for your time
    Kimberly
    Attached Files Attached Files
    Last edited by Kimbersh; 01-19-2021 at 04:43 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Merge two sheets but matching numbers?

    Power Query/Get and Transform is the way to go. Look at the link in my signature for more information.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-03-2021
    Location
    Indiana
    MS-Off Ver
    365
    Posts
    31

    Re: Merge two sheets but matching numbers?

    Thanks, giving it a try

  4. #4
    Registered User
    Join Date
    01-03-2021
    Location
    Indiana
    MS-Off Ver
    365
    Posts
    31

    Re: Merge two sheets but matching numbers?

    Quote Originally Posted by alansidman View Post
    Power Query/Get and Transform is the way to go. Look at the link in my signature for more information.
    I found power query in excel office 365 but I can't see to get this to work. Do you know if there a tutorial that explains this or what keywords would find me the right kind of tutorial?

    Thanks

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Merge two sheets but matching numbers?

    If I am understanding what you want, then look at the attached file where I brought each file into a new workbook. I then promoted the first row to headers. I then merged (joined the two tables)

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    1
    Job Number Job Category Sheet1 (2).Job Name Sheet1 (2).Job ID
    2
    WO 39146 TK-1 Repair sink
    25456
    3
    WO 39143 KONE-Indiana Repair steps
    2657
    4
    WO 39145 TK-Indiana Repair door
    125545
    5
    WO 39144 TK-2 Repair table
    12554
    Sheet: Merge1

    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.
    Attached Files Attached Files

+ 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. Merge Two Sheets Based on Matching Value
    By matthewcb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2014, 05:39 AM
  2. [SOLVED] Matching First and second names and zip codes with ID numbers in two different sheets
    By paulnrswain in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2013, 02:57 PM
  3. Replies: 0
    Last Post: 01-04-2013, 12:25 PM
  4. Merge two sheets into one matching dependents to employee records
    By nabberooski in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 12-06-2012, 06:04 PM
  5. Matching ID numbers from different spread sheets
    By Zavtacular in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2012, 02:08 PM
  6. Replies: 4
    Last Post: 10-06-2011, 12:57 PM
  7. Need to match data on 2 sheets and merge matching
    By innovativesmoking in forum Excel General
    Replies: 1
    Last Post: 08-23-2010, 12:03 AM
  8. Finding matching text/numbers on 2 sheets
    By raehippychick in forum Excel General
    Replies: 3
    Last Post: 05-09-2007, 04:12 AM

Tags for this Thread

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