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)   Scripts CompanyCode FiscalYear DocumentNumber S(0-25)-1 US29 2024 5101197126 S(0-25)-1 US...
Need Help
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.

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

        Hi I want to remove duplicates from A column without impaction on other column