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