Forum Discussion
Replace null values in duplicates
If I have a sorted table like below: Fruit Colour Apple null Apple Red Banana Yellow Pear null How can I replace the null value in "Colour" with the correct value base...
= Table.Combine(Table.Group(#"Sorted Rows","Fruit",{"n",each Table.ReplaceValue(_,null,List.Last([Colour]),Replacer.ReplaceValue,{"Colour"})},0)[n])
= Table.Combine(Table.Group(#"Sorted Rows","Fruit",{"n",each Table.ReplaceValue(_,null,List.Last([Colour]),Replacer.ReplaceValue,{"Colour"})},0)[n])