This guide explains how to fill in gaps in your dataset using Power Query in Microsoft Excel or Power BI. When working with table data (such as CSV exports), empty cells can appear across rows, making analysis difficult. This method helps you clean and standardise your data so each row contains the required values.
Video Walkthrough
Prerequisites
Before you begin make sure you have the following:
Plan: All Plan Types
Permission: Dashpivot Contributor
Skills Required: Excel-based Data Querying
Device Type: Computer/Browser
Subscription: Flowsite, Microsoft Excel, Power BI
Step-by-Step Instructions
Open the Power Query editor.
Right-click on the column you want to fill down.
Select the Replace Values option and replace empty values (leave the box blank) with
"null".Right-click the column again and select the Fill Down function to complete the process.
Notes
Empty cells in CSV outputs commonly occur when working with table data across multiple rows.
Filling down ensures each row contains consistent and usable data for analysis.