How to create a dynamic table in excel to summarize data

Creating a dynamic table in excel

In this example, we will be creating a dynamic table in excel from a dataset. The dataset has 3 columns out of these three 2 are categorical values while the third is numerical. Now we wanted to create a dynamic table that will have these two columns as rows and columns. Also, we wanted to summarise our data by as count of entries of these two categorical columns. Dataset is illustrated in the below image.

Creating a dynamic table in excel
Creating a dynamic table in excel

To create this kind of excel dynamic table we will first convert our dataset into the excel table. You must be wondering why we are converting this into the table, this is because … Continue Reading