Pivot table

EmEditor is able to create pivot tables to output summary statistics about a dataset. The summary may be a count, sum, average, max, or min. A pivot table is best explained through an example. Here, we have a COVID-19 case dataset which has columns for date, country, and new case count.

Using this data, we want to create a table that lists every country on each row and shows the chronological progression of new case counts. Go to CSV > Advanced > Pivot Table….

Select the Sum type

(The type doesn’t matter in this case since
the result cells are 1:1 with the original)

Columns: 1: Date_reported, Sort Date

Check Total in rows

Rows: 3: Country, Sort A to Z

Values: 5: New_cases

Check Total in columns

After clicking OK, a pivot table is created with the result we wanted. The total for each country is shown in the last column and the total for each day is shown in the last row.

We can reverse the pivot operation using Unpivot.

This example shows how a pivot table is a powerful tool in aggregating and summarizing large datasets.