Forum Discussion

onedayover's avatar
onedayover
Helper III
3 years ago
Solved

Remove rows in Power Query based on duplicates in one column and a specific value in another

Hi All I have a table that has duplication in the rows with the exception of 1 column. I've tried to remove certain rows by maniplating some examples which I found but am having trouble trying to ge...
Need Help
  • MahyarTF's avatar
    MahyarTF
    3 years ago

    Hi,

    This is my solution based on the sample data :

    1- I created the Duplicated columns for the ItemId and Status

    2- Merge created columns (Copy-Itemid and Copy-Status)

    3- Sort rows Ascending on the Merged column :

    4- Select the Columns (as below) and remove the duplicated records :

    Also, you could delete the merged column

    Appreciate your Kudos and please mark it as a solution if it helps you.

MahyarTF's avatar
MahyarTF
Memorable Member
3 years ago

Hi,

This is my solution based on the sample data :

1- I created the Duplicated columns for the ItemId and Status

2- Merge created columns (Copy-Itemid and Copy-Status)

3- Sort rows Ascending on the Merged column :

4- Select the Columns (as below) and remove the duplicated records :

Also, you could delete the merged column

Appreciate your Kudos and please mark it as a solution if it helps you.

onedayover's avatar
onedayover
Helper III
3 years ago

Works perfectly, thank you MahyarTF, your help is much appreciated 🙂

  • MahyarTF's avatar
    MahyarTF
    Memorable Member
    3 years ago

    Hi onedayover 

    Glad to help any time