How to count different items in the same column

How to do this depends on what you want for output.

For example, if you want a table where the dates are in one column, and the Appointment Types are listed in individual columns, then the following code will do that.

Assuming your data is in an Excel table:

• Select some cell in your original table
• Data => Get&Transform => From Table/Range or `From within sheet`
•  When the PQ UI opens, navigate to `Home => Advanced Editor`
•  Make note of the Table Name in Line 2 of the code.
•  Replace the existing code with the **M-Code** below
•  Change the table name in line 2 of the pasted code to your "real" table name
• Examine any comments, and also the `Applied Steps` window, to better understand the algorithm and steps

let

//change Table name in next line to your "real" table name in your workbook
    Source = Excel.CurrentWorkbook(){[Name="Table11"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Appointment Date", type date}, {"Appointment Type", type text}}),

//Group by Date
// Then Pivot by Appointment Type after equating the LVL's
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Appointment Date"}, {
        {"pivot", (t)=>let 

        //Transform the "Type" column to "equate" the LVL types
            combineTypes = Table.TransformColumns(t, {"Appointment Type", each if Text.StartsWith(_,"LVL") then "LVL" else _}),

        //pivot on Appointment Type with a Count aggregation
            pivot = Table.Pivot(combineTypes,List.Distinct(combineTypes[Appointment Type]), "Appointment Type", "ID", List.Count)
        in 
            pivot}
        }),

//remove now unneeded date column and expand the Pivoted table
    #"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"Appointment Date"}),

//create dynamic list of column names
//I am assuming that the first column is "Appointment Date".  If not, a more complex algorithm will be needed.
colNames = List.Distinct(List.Accumulate(#"Removed Columns"[pivot],{},(state,current)=> state & Table.ColumnNames(current))),

    #"Expanded pivot" = Table.ExpandTableColumn(#"Removed Columns", "pivot", colNames,colNames),

//set the data types
    typeIt = Table.TransformColumnTypes(#"Expanded pivot", 
        {{colNames{0}, type date}} & List.Transform(List.RemoveFirstN(colNames,1), each {_, Int64.Type}))
in
    typeIt

for example: 

Levels 1 and 2 are the ones lumped together. 

Thanks, I tried implementing this but got confused by the syntax used. Is there a simpler way to do this?