Forum Discussion

3 Replies

  • Thingsclump's avatar
    Thingsclump
    Resolver V
    4 years ago

    Hi Anonymous 

     

    Best way is to select column 1 and column 2 before group by and remove duplicates. 

     

    Thanks

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi Anonymous 

     

    Another way is to filter rows according to Werk column string length after grouping. Duplicated rows have longer strings than others. 

    = Table.SelectRows(#"Grouped Rows", each Text.Length([Werk])<=4)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.