We now want to fix our Type data. Notice that the Type column contains spotty information. The first twelve rows contain the word Budget, and then there is a gap until row 97, where the next twelve rows contain the word Forecast, and then another gap. We want all of these rows to contain either Budget or Forecast. To fix the data, we will use the Fill functionality by performing the following steps:

1. Select the Type column, then right-click and choose Fill, and then Down.
2. Notice that our Type column now contains a value for each row, and a Filled Down step appears in our Applied Steps area.

The Fill operation takes the latest value found in the column and replaces any blank or null values with that value until a new value is found and the operation repeats.