Results 1 to 6 of 6

Thread: Help with merging two data sets to create a "complete picture"

  1. #1
    Neophyte perks84's Avatar
    Join Date
    Aug 2019
    Posts
    2
    Articles
    0
    Excel Version
    office 365

    Help with merging two data sets to create a "complete picture"



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have two data sets from an ERP system that i need to merge to create a complete picture of a transaction series. I have been battling for a couple of weeks so am reaching out for help.

    Data set 1 Data Set 2
    WorkOrder SalesOrder Movement SLoc Pounds Work Order Sales Order Movement SLoc Pounds
    711 "blank" 261 9998 260 711 "blank" 261 9998 -260
    711 782 101 9999 -207 blank" 782 601 9999 -207
    712 782 601 9999 -101

    Desired data set
    WorkOrder, SalesOrder Movement SLoc Pounds
    711 782 261 9998 260
    711 782 101 9999 -207
    711 782 261 9998 -260
    711 782 101 9999 207
    711 782 601 9999 -207
    712 782 601 9999 -101
    Last edited by perks84; 2019-08-14 at 02:12 AM.

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    178
    Articles
    0
    Excel Version
    2019
    It is easier to work with a sample workbook instead of what you have provided. Suggest you upload to this site a small sample workbook.

  3. #3
    Neophyte perks84's Avatar
    Join Date
    Aug 2019
    Posts
    2
    Articles
    0
    Excel Version
    office 365

    Sample excel workbook below

    Quote Originally Posted by alansidman View Post
    It is easier to work with a sample workbook instead of what you have provided. Suggest you upload to this site a small sample workbook.
    The challenge is also to replace the "blank" cells with the correct deduced numbers

    Data Set 1 / Query 1
    WorkOrder Sales Order Movement Sloc Pounds
    711 "blank" 261 9998 -260
    711 782 101 9999 207
    Data Set 1 / Query 1
    WorkOrder Sales Order Movement Sloc Pounds
    711 "blank" 261 9998 -260
    711 782 101 9999 207
    "blank" 782 601 9999 -207
    712 782 601 9999 -100
    Merged Data Set / Merged Query
    WorkOrder Sales Order Movement Sloc Pounds
    711 782 261 9998 -260
    711 782 101 9999 207
    711 782 261 9998 -260
    711 782 101 9999 207
    711 782 601 9999 -207
    712 782 601 9999 -100

  4. #4
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,666
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Please upload a sample workbook. Click Go advanced - Manage attachments" - NO PICS PLEASE
    Thank you Ken for this secure forum.

  5. #5
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,652
    Articles
    0
    Excel Version
    O365
    Quote Originally Posted by perks84 View Post
    The challenge is also to replace the "blank" cells with the correct deduced numbers
    That data is not very helpful as there are only two WorkOrder numbers and all of the resulting sales Order numbers are the same. What is the rule for 'deducing' those numbers?
    Last edited by Bob Phillips; 2019-08-16 at 10:58 AM.

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,245
    Articles
    0
    Excel Version
    Office 365 Subscription
    For the THIRD time: please upload a sample WORKBOOK. Thanks.
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

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