I have an Excel sheet which is sparsely filled:
I'm looking for a way to turn the left column into the right column. Basically all empty rows should be set to the first filled row above them.
Is there a way to do this? The sheet is awfully large (60.000 rows.)