Forum Discussion
Fill blank cells with values from a cell beside it (not merge)
Hi everyone, Is there an easy way that excel can help fill in blanks efficiently if there are multiple columns that might have similar data and you want bring multiple columns together into one. ...
My knowledge of PQ is limited (to put it mildly :), but I was able to find this solution proposal on the internet.
Power Query Editor by using the Table.ReplaceValue function.
For example, you can use this code:
= Table.ReplaceValue(#“Changed Type”,null,[ID of Product],Replacer.ReplaceValue,{“Product ID”})
This will replace any null values in the Product ID column with the values from the ID of Product column.
I hope this helps.