Hi,

I am writing regarding the Pivot table creation with data which contains empty rows.

Recently, I work on a project with a data which contains empty rows. I will attach the file for sample to see what sort of data contains my sheet.

As you can see the data is divided according to some criteria, and it is constantly updated by users. sometimes a new criteria is added at the end of the sheet, that is why I need to create a pivot table, to be able to just changing Source, to update the table and manipulate table in order to get desired results, but I can’t remove these empty rows rom the data as far as some unexperienced users have to fill the information and it is more comfortable to have the data separated from each other for them.

However, when creating the Pivot table on this type of data, the pivot table will include the blanks Row Labels there.

It can be removed by excluding them using filtering, but can someone provide any better way? Can I build a pivot table on this type of data without spaces?

Any suggestions are welcomed.

Thank you in advance.

The sample file:

data_sample.xlsx