Forum Discussion

KuntalSingh's avatar
KuntalSingh
Icon for Helper V rankHelper V
2 years ago

Need help on removing duplicates records from columns

I want to remove duplicates records from column A (Script) and Column D (Document Number)

 

ScriptsCompanyCodeFiscalYearDocumentNumber
S(0-25)-1US2920245101197126
S(0-25)-1US2920235100017080
S(0-25)-1US2820245101413528
S(0-25)-1US2820245101491591
S(0-25)-1US2820245101566015
S(0-25)-1US2820245101567516
S(0-25)-1US2820245101752521
S(0-25)-1US2820245101874011
S(0-25)-1US2920245101149040
S(0-25)-1US2920245101984655
S(0-25)-1US2820245101413527
S(0-25)-1US2820245101575516
S(25-60)-1100020245135751891
S(25-60)-1100020245135751741
S(25-60)-1100020235132476310
S(25-60)-1100020245135737969
S(25-60)-1100020245135738340
S(25-60)-1100020245135513389
S(25-60)-1US2820245100822034
S(25-60)-1US2820245101126254
S(25-60)-1US2820245101239148
S(25-60)-1US2820245101580014
S(25-60)-1100020235133914906
S(25-60)-1100020245135751575
S(25-60)-1100020235133931734
S(25-60)-1100020245135737845
S(25-60)-1100020245135726814
S(25-60)-1100020245135726814
S(25-60)-1US2820245100826506
S(25-60)-1US2820245100961501
S(25-60)-1100020245134521776
S(25-60)-2US2820245101315626
S(25-60)-2US2820245100942417
S(25-60)-2US2820245101072040
S(25-60)-2US2820245100942418
S(25-60)-2US2820245101124138
S(25-60)-2US2920241700262501
S(25-60)-2US2920241700290000
S(25-60)-3US2820245101410515
S(25-60)-3US2820245101572028
S(25-60)-3US2920245100942062
S(25-60)-3US2920245101100656
S(25-60)-3US2920245101525526
S(25-60)-3US2920245101745551
S(25-60)-3US2920245100921753
S(25-60)-3US2920245100979147
S(25-60)-3US2920245101125635
S(25-60)-3US2920245101488517
S(25-60)-3US2820245100909529
S(25-60)-3US2820245101166021
S(25-60)-3US2820245100822035
S(25-60)-3US2820245101838516
S(25-60)-3US2920245101742535
S(25-60)-3US2920235101103533
S(25-60)-3US2920235101984002
S(25-60)-3US2820245100905979
S(25-60)-3US2820245101510053
S(25-60)-3100020245135738340
S(25-60)-3100020245135513389
S(25-60)-3US2820245100965506
S(25-60)-3US2820245101205008
S(25-60)-3US2820245100924846
S(25-60)-3US2820245101526515
S(25-60)-3US2820245100905981
S(25-60)-3US2820245101331567
S(25-60)-3US2820245100935641
S(25-60)-3US2820245101025569
S(25-60)-3US2820245100935615
S(25-60)-3US2820245102247526
S(25-60)-3US2820245100877090
S(25-60)-3US2820245101177617
S(25-60)-3US2820245100993628
S(25-60)-3US2820245101315626
S(25-60)-3US2820245100942417
S(25-60)-3US2820245101072040
S(25-60)-3US2820245100942418
S(25-60)-3US2820245101124138
S(25-60)-3US2920245100864027
S(87-100)-5US2820235501539190
S(87-100)-5US2720245100295502
S(87-100)-5US2720235100095003
S(87-100)-5US2820235500954500
S(87-100)-5US2720235100017500
S(87-100)-5US2720245100606001
S(87-100)-5US2720245100453500
S(87-100)-5US2820231900516000
S(87-100)-5US2820231900532500
S(87-100)-5US2720235100009501
S(87-100)-5US2720235100324000
S(87-100)-5US2720245100839500
S(87-100)-5US2820235101780500
S(87-100)-5100020245135714076
S(87-100)-5100020245135751697
S(87-100)-5100020245135727111
S(87-100)-5100020245135751698
S(87-100)-5100020245135704059
S(87-100)-5100020245135751750
S(87-100)-5US2920245101753072
S(87-100)-5US2920245101768506
S(87-100)-5US2920245101876001
S(60-87)-4US3020245500462638
S(60-87)-4US3020245500579546
S(60-87)-4US3020245500582076
S(60-87)-4US3020245500338540
S(60-87)-4US2820245501626564
S(60-87)-4US2820245500563394
S(60-87)-4US2820245501081482
S(60-87)-4US2820245501698726
S(60-87)-4US2820245501713008
S(60-87)-4100020245135738198
S(60-87)-4100020245135738200
S(60-87)-4US2820245501005962
S(60-87)-4US2820245501472926
S(60-87)-4US3020245501174535
Need Help

14 Replies

  • Gabry's avatar
    Gabry
    Icon for Super User rankSuper User
    2 years ago

    Hello,

    You just need to open power query, select both columns, right click and "Remove duplicates"

    • KuntalSingh's avatar
      KuntalSingh
      Icon for Helper V rankHelper V
      2 years ago

      I tried to remove duplicates by selecting both column but it does't work

      • dufoq3's avatar
        dufoq3
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Hi, it should work. Are you sure that there are not any trailing spaces in data etc? Provide screenshot of duplicates after removig duplicates please.