Forum Discussion
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...
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]))
hi AlienSx , it worked pefrectly, thank you for that. so, it was not a matter of transposing/pivoting, it was a matter of grouping/consolidating instead, got it 🙂