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...
Need Help
  • 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]))
AlienSx's avatar
AlienSx
Super User
2 years ago

Hello, GeorgeGiannakis I have not renamed columns to Market1, Market2 etc. But it's doable.

let
    Source = your_table,
    group = Table.Group(Source, {"Product"}, {{"x", (x) => {Table.FirstValue(x)} & x[Market]}})[[x]],
    to_table = Table.FromColumns(List.Zip(group[x]))
in
    to_table