Courses / Power Query (Get & Transform)
16. Fill Down / Fill Up
Filling null or blank cells downwards or upwards within a column to propagate values.
Power Query M
Fill Down / Fill Up
A way to propagate non-empty values downward or upward in a column so every row gets the nearest value above (Fill Down) or below (Fill Up).
"I have rows where a value is listed only once and the following rows are blank — I want those blanks to show the same value without typing it repeatedly."
Fill Down (or Fill Up) scans a column and replaces null cells by the nearest non-null value above (or below), effectively propagating values across runs of nulls.
"I have rows where a value is listed only once and the following rows are blank — I want those blanks to show the same value without typing it repeatedly."
Fill Down (or Fill Up) scans a column and replaces null cells by the nearest non-null value above (or below), effectively propagating values across runs of nulls.