You can remove the DataPilot fields to define your desired
data structure in DataPilot table.
Remove the fields from an area by doing one of the following:
- Click the button on one of the fields or right-click one
of the fields, and select Remove from Areas.
- Drag the field from the area to the field list.
- Right-click the items in one of the areas, and select Remove.
- Right-click the DataPilot table, on the context menu, select Remove
Fields..
- Drag the field from the one to another in the DataPilot
table.