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]))
I would also recommend to consider this book (on the first page of Rick's web site): Definitive Guide to Power Query (M). I don't have it but it's table of contents looks promising. Web site itself is also very helpful.
Thank you AlienSx , just finished the "M is for Data Monkey" by K.Puls and M.Escobar and was looking for new material