How to Count Number of Rows for Each Categorical Value

As an example, I will count number of rows (number of flights) for each airline carrier in this flight data.

Group the rows by CARRIER, by following column header menu like this.

Rows are grouped by CARRIER now.

Click Add button, and select Summarize (Aggregate) menu.

In the Summarize dialog, select (Number of Rows), and give a name for the new column to store the result.

Click Run button to get summarized table with number of rows for each airline carrier.