Dynamically choose field

Need help Database
1

Hello, I am trying to display data based on a users data. For example, this is what I have so far.

Untiasdasdtled

I have the data for each state, but want to choose the the field dynamically rather than selection a specific state. Is there any way to do this?

2

What you have there is a “pivot table”, which is in a form that is hard to use.

The database would work better if you can unpivot the region-separated data into something like :

State      Party  Influence
---------------------------
Ohio       party1  1.1
Oregon     party2  9.9
Okra       party2  5.7
Okalahama  party1  3.2
4

Thank you! I don’t know why I couldn’t figure that out.