Filling blank cells with values from preceding ones is a common task for Excel users. Unfortunately, it is performed inefficiently most of the time, based on my experience.
In this video, I present an efficient trick to fill blank cells regardless of their count using the “Go To” wizard.