When you work with large spreadsheets, where the amount of data seems overwhelming, or with spreadsheets where you want to quickly rearrange how the data is displayed or summarized, you can use the DataPilot to create a pivot table. The DataPilot's table cross-tabulates the information into rows and columns, making it easy for you to quickly analyze the data.
Since you can manipulate a DataPilot table even after you've created it, you can view your data in different ways without creating different tables from scratch. The DataPilot table derives its data from your original spreadsheet, so if you delete the DataPilot table, you aren't affecting the original spreadsheet at all.
You can ...