Forum Discussion

GeorgeGiannakis's avatar
GeorgeGiannakis
New Member
2 years ago
Solved

removing duplicated rows without losing information

Hi all,   Hope you are well 🙂   I need some help with the below table1. The table contains two columns, "Product" and "Market". "Product"column contains duplicated entries. I need to create a...
  • AlienSx's avatar
    AlienSx
    2 years ago

    George_Gian last 2 steps must be 

    #"Group" = Table.Group(#"Sorted Rows",{"Product"},{{"x",(x)=>{Table.FirstValue(x)} & x[Market]}})[[x]],
    #"To_table" = Table.FromColumns(List.Zip(#"Group"[x]))