Blanking and Filling Cells

In a column, you can use the blanking down function to clear the cells that contain the same value as a preceding cell, and use the filling down function to fill empty cells with the value contained in a preceding column.

Take the following data as an example. There are same cell values in the StudentId column.

Click the StudentId column and click Edit cells > Blank down. The cells that contains the same value are cleared. Only the first same cell value is reserved.