Results 1 to 6 of 6

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

Threaded View

Previous Post Previous Post   Next Post Next Post
  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"

    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.

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
  •