"merge" similar rows in pivot table?

To merge the rows in your database for analysis, you can follow these steps:

1. Create a pivot table using your database as the data source.
2. Place the "Show" column in the rows section of the pivot table.
3. Place the "Feedback" column in the values section of the pivot table.
4. Change the aggregation function for the "Feedback" column to count.
5. This will give you the count of feedback for each show.

To handle the issue of void cells, you can make use of the "Show" column. Follow these additional steps:

1. Insert a new column next to the "Show" column in your database.
2. In the first cell of the new column, use a formula to check if the "Show" cell is empty or not. For example, if your "Show" column is column A, enter the formula "=IF(A2<>"", 1, 0)" in cell B2.
3. Drag the formula down to fill the remaining cells in the new column.
4. When creating the pivot table, include this new column as a filter.

In the pivot table, filter out the rows where the value in the new column is 0. This will exclude the void cells from the analysis.
By using these steps, you can merge the rows in the pivot table to show the count of feedback for each show, and handle the issue of void cells.