Fill Down and Fill Up in Power Query
Reports often show a group name once and leave the rows below it blank. Power Query’s Fill Down copies each value into the empty cells beneath it, and Fill Up copies upwards, so the data is ready for a PivotTable. WhereRight-click a column → Fill → Down or Up Fillsnull cells only Works inExcel 2016 … Read more