Table.FillDown

Returns a table extracted from the specified table, in which the values from cells above are filled into any null cells below in the designated columns.

Syntax

Table.FillDown(table as table, columns as list) as table

About

Returns a table extracted from the specified table, in which the values from cells above are filled into any null cells below in the designated columns.

Explanation

Generate a table where the empty values in the "Place" column are replaced with the value above them in the table using Power Query MTable.FillDown function. The initial table includes records with names and corresponding place values. The function fills in the null values in the "Place" column based on the value above them. The output table retains the original records but with the null values in the "Place" column filled with the value from the record above.