Just wondering if this is possible,

I have a table in SQl that I want to export into Excel, which is pretty straight forward. Instead of transporting to a single worksheet tab in Excel, I want the data to be split based on a specific column into different worksheet tabs

For Example,

SELECT * FROM MyTable

Student Course Amount
2549 Art 100
3254 Science 300
3285 Art 234
2317 Art 674

So when I’ve exported the data to Excel, There should be 2 tabs labelled Art, Science, with the appropriate data in them

Can this be done?