Hi
try the following steps
1. Get rid of the merged cells above your table.
2. Make a header for each column ( say colour, fruit, nr)
3 Select a cell in th range - "Insert" Ribbon - Click "Table"
4. In the Table Tools ribbon that appeared select "summarize with Pivot Table"
5. Creat your PT as desired
6. After adding data, right click the PT and click " Refresh"

You can also add a small macxro to auto refresh, they are all over the Net

Good luck

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post