Fill Data in Blank Rows (Power Query Editor)

venug20

I used this

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Company", type text}, {"City", type text}}),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1),
    #"Trimmed Text" = Table.TransformColumns(#"Added Index",{{"Company", Text.Trim, type text}, {"City", Text.Trim, type text}}),
    #"Sorted Rows" = Table.Sort(#"Trimmed Text",{{"Company", Order.Ascending}, {"City", Order.Descending}}),
    #"Filled Down" = Table.FillDown(#"Sorted Rows",{"City"}),
    #"Sorted Rows1" = Table.Sort(#"Filled Down",{{"Index", Order.Ascending}}),
    #"Removed Columns" = Table.RemoveColumns(#"Sorted Rows1",{"Index"})
in
    #"Removed Columns"