before you create a pivot table it is important to

Answer 1

ensure that your data is organized in a tabular format. This means that each column should contain similar data and each row should contain related data. Additionally, it is important to make sure that there are no blank cells or duplicate values in the data.