This is probably so simple a caveman can do it (no offense to any neanderthals that may be reading) but apparently, it's too difficult for me to figure out.
I have a data table in which the data will update regularly. I'm trying to figure out how to make the table update when the data updates. I've attached a simple example of what I'm trying to achieve.
To explain, though... I have a list of people and fruit they've chosen. The table would contain those same people and would count how often they chose each fruit. In my real world file, the people will change, therefore the fruit choices change. However, the fruit categories themselves, will always remain the same.
Thanks for looking!
Bookmarks