Transpose column against repeated cells

I don't understand why you are using the old .xls format with Excel 2013. I have provided a solution using PowerQuery:

M Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"CONSIGNEE", type text}, {"AC#", Int64.Type}, {"WR#", Int64.Type}, {"DESCRIPTION", type text}, {"LBS", Int64.Type}, {"SHIPPER", type text}, {"PHONE", type text}, {"EMAIL", type text}, {"ADDRESS", type text}, {"VALUE", type number}, {"%", Int64.Type}, {"FREIGHT", type number}, {"FUEL", type number}, {"CUSTOMS & DUTY", type number}, {"VAT", type number}, {"ONLINE PURCHASE TAX", type number}, {"INSURANCE FEE", type number}, {"BROKERAGE FEE", type number}, {"TOTAL", type number}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"CONSIGNEE", "AC#", "WR#", "DESCRIPTION", "LBS", "SHIPPER", "PHONE", "EMAIL", "ADDRESS"}, "Attribute", "Value.1"),
    #"Filtered Rows" = Table.SelectRows(#"Unpivoted Other Columns", each ([Attribute] <> "%" and [Attribute] <> "TOTAL" and [Attribute] <> "VALUE"))
in
    #"Filtered Rows"