Filling in the Blanks

Hello, LWBB if I understood your message correctly, you want each unique combination of Section and Location to have the same (non blank) descriptions. You can do that by grouping data by Section and Location while don't aggregate any other columns but use "All Rows" option. Then apply Table.FillUp and Table.FillDown to Section Descr and Location Descr columns of your tables. Smth like this:

let
    Source = your_table,
    g_columns = {"Section", "Location"}, 
    descr = {"Section Descr", "Location Descr"},
    e_columns = List.RemoveItems(Table.ColumnNames(Source), g_columns),
    g = Table.Group(
        Source, g_columns,
        {"groups", each 
            Table.FillDown(
                Table.FillUp(_, descr),
                descr)}
    ),
    expand = Table.ExpandTableColumn(g, "groups", e_columns)
in
    expand