Skip to main content
All CollectionsSupport GuideFlowsite Power BI
How to fill in gaps using Power Query
How to fill in gaps using Power Query
Jasvir avatar
Written by Jasvir
Updated over a week ago

Using Power Query via Excel or Power BI, you can clean up your data so that every line has the data required.

When a table is present in a form, the CSV output has empty cells in columns for each additional row of the table.

How to fill these gaps using Power Query?

  1. Open the Power Query editor

  2. Right click on the column you want to fill down

  3. Select the replace values option and replace empty value (i.e. don't fill in box) with "null"

  4. Then right click the column again and select the fill down function to complete the process

Did this answer your question?