Machine software generated Spreadsheet issues

Teessiderang 

If you have Power Query...

1) Click in the report,

2) Data > From Table/Range - That brings up Power Query
3) Click Advanced Editor.

4) Copy/Paste the code at bottom into Advanced Editor
5) Click Done > Close & Load

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    RmvCols = Table.RemoveColumns(Source,{"Column6", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column3", "Column4", "Column1", "Column14", "Column16", "Column17", "Column18", "Column20", "Column21", "Column22", "Column23", "Column24", "Column25", "Column26"}),
    RmvBlkRows = Table.SelectRows(RmvCols, each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
    RmvRows1 = Table.SelectRows(RmvBlkRows, each ([Column19] <> null)),
    KeepToss = Table.AddColumn(RmvRows1, "Keep", each if Text.Contains([Column19], "/") or
                                              Text.Contains([Column19], ".") or
                                              Text.Contains([Column19], ":") 
                                              then "Toss" else "Keep"),
    RmvRowsToss = Table.SelectRows(KeepToss, each ([Keep] = "Keep")),
    RmvColKeepToss = Table.RemoveColumns(RmvRowsToss,{"Keep"}),
    RmvRowsCol2Null = Table.SelectRows(RmvColKeepToss, each ([Column2] <> null)),
    RmvRows2 = Table.SelectRows(RmvRowsCol2Null, each ([Column5] <> "1.1 SUBSTRUCTURE" and [Column5] <> "ASSUMPTIONS AND CLARIFICATIONS") and ([Column2] <> "2/1"))
in
    RmvRows2