Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.
I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results