I have 10 fields in my table that represent year 1-year 10. I want to group a report by the year represented in the field, not by the field itself. For example, one result may look like this:

...and so on
The next result may be:

I want to group by the year, so that I can sum quarterly amounts for each year (i.e. 2023, 2024, etc.) This is a simple, one table report that needs to sum amounts for each quarter of each year for a couple hundred results.
I have tried creating a formula to parse out the year, but can't figure out how to group by the year value and not the field since there are 10 different year fields.