Sorting by multiple columns and creating a distinct count helper column

Hi,

I have a dataset, which has multiple order IDs, some orders only contain one product and therefore occupy only one row. Some orders have multiple products and have multiple rows assigned to them. 

This datasheet is than printed and submitted in the warehouse with the information what to pack. For the warehouse to be efficient it would make sense that all the identical product would be sorted together. But the problem is that if the order contain multiple products and than has multiple rows those need to be side by side - because they need to be packed together. 

I want to filter by products so the sheet has ordered products but also taken in the account if the order contains multiple products those should not be separated.

I think the solution should be done by:

1. creating a helper column which counts how many times the unique order.id appears in the dataset. 
2. than sort by:

   2.1. Item.id

   2.2. helper counter column

   2.3. Order.Id

those 3 layered filter would probably create a the desired result.  The reuslt I am looking for:

Below is the current code which does not entail the sorting function, because I do not know how to implement the helper count distinct column. 

let
    Source = Csv.Document(File.Contents("C:\Us...ta\I.csv"),[Delimiter=";", Columns=15, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Order.id-Ihre.Referenz", Int64.Type}, {"Vorname_firstName", type text}, {"Nachname_lastName", type text}, {"Firma_companyName", type text}, {"Strasse_street", type text}, {"Hausnummer_houseNumber", Int64.Type}, {"Ansprechperson_address3", type text}, {"Ort_town", type text}, {"PLZ_zip", Int64.Type}, {"Land-country", type text}, {"email", type text}, {"phone", type text}, {"Variation.number", type text}, {"Variation.name", type text}, {"Variation.quantity", Int64.Type}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Strasse_street", "Hausnummer_houseNumber", "Ansprechperson_address3", "Ort_town", "PLZ_zip", "Land-country", "email", "phone"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([Variation.number] <> "")),
    #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each not Text.Contains([Variation.number], "-")),
    #"Filtered Rows2" = Table.SelectRows(#"Filtered Rows1", each not Text.Contains([Variation.number], "_")),
    #"Removed Columns1" = Table.RemoveColumns(#"Filtered Rows2",{"Vorname_firstName", "Firma_companyName"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns1",{{"Nachname_lastName", "LastName"}, {"Order.id-Ihre.Referenz", "Order.id"}, {"Variation.quantity", "Quantity"}}),
    #"Grouped Rows" = Table.Group(#"Renamed Columns", {"Order.id", "LastName", "Variation.number", "Variation.name"}, {{"Quantity", each List.Sum([Quantity]), type number}}),
    #"Replaced Value" = Table.ReplaceValue(#"Grouped Rows","ö","ö",Replacer.ReplaceText,{"LastName"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","ß","ß",Replacer.ReplaceText,{"LastName"}),
    #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","ü","ü",Replacer.ReplaceText,{"LastName"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Replaced Value2",{{"Quantity", Int64.Type}}),
    #"Replaced Value3" = Table.ReplaceValue(#"Changed Type1","ä","ä",Replacer.ReplaceText,{"LastName"}),
    #"Replaced Value4" = Table.ReplaceValue(#"Replaced Value3","Ö","Ö",Replacer.ReplaceText,{"LastName"}),
    #"Filtered - aluprofil" = Table.SelectRows(#"Replaced Value4", each not Text.Contains([Variation.name], "Aluprofil")),
    #"Filtered - alu" = Table.SelectRows(#"Filtered - aluprofil", each not Text.Contains([Variation.name], "ALU"))
in
    #"Filtered - alu"

Thanks for the help!

Andraz