Multiple grade types per column

I have a Year 1 and Year 2 combined class.

I want to be able to have two Grade Types for the one column.

For instance:
Student Year Reading level. Grade
A. 1. 12. C
B. 2. 12. D

So Student A (Year 1) is at a Reading Level of 12 and is achieving a 'C'. Student B (Year 2) is at the same reading level but is achieving a D grade.

I want to pick a different Grade Type depending on what year the student is and apply that to their Reading Level to give me their grade.

Any thoughts please?

My thanks,
Brett

Hello Brett,
I'm afraid it can't be easily solved yet unless you create a folder and two columns inside, each with its own grade type.
Noted, I'll see if we can come up with a more elegant solution