you have been able to do this since like forever, on like every spreadsheet package. It might have had a different name, which could be daunting for an excel user, but essentially the same functionality was always there. On libre office it's even called "pivot table". Paying for office is such a waste of money it's unbelievable.
I understand that office suites are for simple-minded folk, but seriously how dumb do you have to be to pay hundreds of dollars to get essentially the same program as libre office?