Challenge with the Index formula

I think I've covered the column H aspect. Happy to explain if needed.

Glenn Kennedy,

Thanks a lot! I appreciate it. Your formulas work perfect! I am getting there! The only one thing I tried to modify myself, but couldn't

In your formula, the values that are greater than 30 needs to be placed accordingly to the location...

For example, in the spreadsheet that you attached, Name 1, has the value 35 at location 4, this value needs to go under CT column (which is coded as location 4)

Is it possible to modify?

Thanks a lot!!!