Find and replace the null

[Michnia25]

Hi, I need help with my data and I will be appreciated for some support.
I imported data from CSV file and I faced the issue with the core date due to transformation.
On the core file data provide the product and the summary of the components used to produce the product. On the bottom of the summary data provided the date and time when the product was produced.
After importing the data to power query date and time are stored on the separate column as per picture below. My problem is that I need to populate that date and time on the every each record, basically replace the null with the nearest date or time from the below. Is there any way to achieve that?

 

[Micron]

In your sample data there is only one data value. So the first 2 nulls should be 21/03/2022 but IF the date on line 11 was 21/04/2022 then the nulls from lines 4 through 10 should be 21/04/2022, not 21/03/2020? I can only foresee a vba code solution, regardless (or maybe a range formula and I know very little about those).

Is it most likely that when there is a date, it will be the same date anywhere in that column? That would simplify the solution.

 

[alansidman]

In power query use the Fill Up functionality. Highlight the column, right click-->Fill-->Up.

Using Fill Down or Fill Up in Excel Power Query

In our overview blog on the excel power query feature, we had learned about the basics and the introduction of power query in Excel. We also learned how the pow

excelunlocked.com

 

[Michnia25]

In power query use the Fill Up functionality. Highlight the column, right click-->Fill-->Up.

Using Fill Down or Fill Up in Excel Power Query

In our overview blog on the excel power query feature, we had learned about the basics and the introduction of power query in Excel. We also learned how the pow

excelunlocked.com

That is amazing ?. Thank you for that ?