Pivot Tabella. Create a pivottable select the cells you want to create a pivottable from. To get banana at the top of the list.
In table range verify the cell range. Using the example above. Building the pivot table 1.
Ensure that your data meets the needs of a pivot table.
A pivot table is not always the answer you are looking for. Ensure that your data meets the needs of a pivot table. The pivottable fields pane appears. Under choose the data that you want to analyze select select a table or range.
