Spreadsheet: 882703d1731117106-powerquery-4-large-datasets-duplicate-issues-help
Sheet: Sheet1

Work Order | Product IN | Product Out | Serial | VendCustFlag |  | Serial # is unique, no 2 alike |  | Based on Source 1 I would need a query matching my tracker work order to source 1 work order for all serial #'s and other info | I then need to bring in products without serial #s without duplicating products listed by source 1 based on work order | I then would need to bring in all vend code VDOR that do not have a work order # while keeping  the other info - based on serial # (found in source 1) There are a lot of serial #s that are in VDOR status. | I need to bring in vendor comments based on work order and product out |  |  |  |  |  |  |  |  | Problem statement | User Statement
WOZ805320 | p39Z390X | p39Z390c | 789892982 | VDOR |  | Work orders can have multiple Products
WOZ85579Z | p958296X | p958296c | 789900982 | VDOR |  | Products could have multiple serial #'s
[NAME] | p958296X | p958296X | 789891440 | CUST
WO222Z98Z | Z35p00pX | Z35p00pX | 789987777 | VDOR
WO222Z988 | p566520X | p566520X | 789558277 | VDOR
WO222685Z | 772552X | 772552X | 789924007 | VDOR
WO2239p8p | [NAME] | [NAME] | 789952177 | CUST
WO22p5033 | Z88p926X | Z88p926X | 789982245 | VDOR |  |  | MY NEEDS (work order database) | Source 1 (serial database) | Source 2 (Product Database) | Source 3 ([NAME]) | Source 4 (Vendor database)
WO225p508 | ZpZp366X | ZpZp366X | 789988331 | VDOR |  |  | Work order | Work order
WO22692p9 | p888p8ZX | p888p8Zc | 789966523 | CUST |  |  |  | Region
WO22750Z3 | Z885897X | Z885897X | 789981114 | VDOR |  |  |  | Area
WO2277063 | p83Z629X | p83Z629X | 789957256 | CUST |  |  |  | Status
WO228Z8p6 | p850320X | p850320c | 789976Z77 | CUST |  |  |  | Work Type
WO228Z930 | p988372X | p988372X | 789995550 | VDOR |  |  |  | Product in | Product in
[NAME] | p093Z23X | p093Z23X | 789099588 | VDOR |  |  |  | Product Out | Product Out
WO228233p | 80Z092X | 80Z092X | 789093125 | VDOR |  |  | Schedule Date
 |  |  |  |  |  |  |  |  | Permit
 |  |  |  |  |  |  |  | serial
 |  |  |  |  |  |  | Assignment
Example: Same Work Order, mulitple products, multiple serial |  |  |  |  |  |  |  |  |  | VendCustFlag
 |  |  | UNIQUE |  |  |  |  |  |  |  | Problem Statement
WO225p508 | ZpZp366X | ZpZp366X | 789988331 |  |  |  |  |  |  |  | Vendor comments
WO225p508 | ZpZp366X | ZpZp366X | 789245531
WO225p508 | ZpZp366X | ZpZp366X | 789000329
WO225p508 | 80Z092X | 80Z092X | 789093125
WO225p508 | 80Z092X | 80Z092X | 789006523
WO225p508 | p888p8ZX | p888p8Zc | 789967444
WO225p508 | Z885897X | Z885897X | 789981114 |  |  |  | Work order, Product any other field can duplicate as long as there is a "unique" serial #
WO225p508 | Z885897X | Z885897X | 789981258
 |  |  |  |  |  |  | There are times when products do NOT have serial #'s They need to be captured also (source 2 does not have serial numbers for these products)
 |  |  |  |  |  |  | If there is a serial # there is always a product
I need to gather something like the below but not have duplicates happen, yet capturing ALL DATA
The below has captured all data.  This is what I need the report to look like.  No duplicates unless there is a serial #
Missing data gets researched.
Area | Region | Work Order | ATP For Construction | Status | WO Sent to VDOR | Commodity | VEN Report | permit | Serial | City | Product In | Product Out
A96 | West | WOZ805320 |  | Ordered |  | Frame | VDOR | no |  | ackon | p39Z390X | p39Z390c
[NAME] | North | WO228233p | 2024-09-28 00:00:00 | Ordered |  | Frame |  | no |  | allenton | 80Z092X | 80Z092X
[NAME] | North | WO228233p | 2024-09-28 00:00:00 | Ordered |  | Frame |  | no | 789093125 | allenton | 80Z092X | 80Z092X
[NAME] | North | WO228233p | 2024-09-28 00:00:00 | Ordered |  | Frame |  | no |  | allenton | 80Z091X | 80Z091X
A62 | West |  |  |  |  | Frame | VDOR | no | 789242424 | [NAME] | dd3987z8 | dd3987z8
A62 | West |  |  |  |  | Frame | VDOR | no | 789922455 | [NAME] | dd3987z8 | dd3987z8
A96 | West | WO225p508 | 2024-10-02 00:00:00 | SENT | 2024-10-01 00:00:00 | Prints | VDOR | no | 789988331 | Bristol | ZpZp366X | ZpZp366X
A96 | West | WO225p508 | 2024-10-02 00:00:00 | SENT | 2024-10-01 00:00:00 | Prints | VDOR | no | 789245531 | Bristol | ZpZp366X | ZpZp366X
A96 | West | WO225p508 | 2024-10-02 00:00:00 | SENT | 2024-10-01 00:00:00 | Prints | VDOR | no | 789000329 | Bristol | ZpZp366X | ZpZp366X
A96 | West | WO225p508 | 2024-10-14 00:00:00 | SENT | 2024-10-08 00:00:00 | Prints | VDOR | no | 789093125 | Bristol | 80Z092X | 80Z092X
A96 | West | WO225p508 | 2024-10-14 00:00:00 | SENT | 2024-10-08 00:00:00 | Prints | VDOR | no | 789006523 | Bristol | 80Z092X | 80Z092X
A96 | West | WO225p508 | 2024-10-02 00:00:00 | SENT | 2024-10-01 00:00:00 | Prints | VDOR | no | 789967444 | Bristol | p888p8ZX | p888p8Zc
A96 | West | WO225p508 | 2024-10-02 00:00:00 | SENT | 2024-10-01 00:00:00 | Prints | VDOR | no | 789981114 | Bristol | Z885897X | Z885897X
A96 | West | WO225p508 | 2024-10-02 00:00:00 | SENT | 2024-10-01 00:00:00 | Prints | VDOR | no | 789981258 | Bristol | Z885897X | Z885897X