If you insert a pivot table on your data, drag these columns into the Row Labels:
Then drag this column into the Column Labels:
Drag the same column into Values:
The pivot table looks almost the same as yours (except the fruit comes under the name, instead of repeating the name for each fruit).
Whenever you update the data in sheet 1, you may have the pivot table reflect this by right-clicking on the table and choosing Refresh.
If you insert a pivot table on your data, drag these columns into the Row Labels:
Then drag this column into the Column Labels:
Drag the same column into Values:
The pivot table looks almost the same as yours (except the fruit comes under the name, instead of repeating the name for each fruit).
Whenever you update the data in sheet 1, you may have the pivot table reflect this by right-clicking on the table and choosing Refresh.
If you insert a pivot table on your data, drag these columns into the Row Labels:
Then drag this column into the Column Labels:
Drag the same column into Values:
The pivot table looks almost the same as yours (except the fruit comes under the name, instead of repeating the name for each fruit).
Whenever you update the data in sheet 1, you may have the pivot table reflect this by right-clicking on the table and choosing Refresh.
