How can turn attributes into fields?

Question

I am trying to re-arrange my standalone table so I can calculate a new field. I want to calculate the difference between the 2020 count and the 2007 for each state. To do this, I would like to create a 'State' field, a '2007 count' field, and a '2020 count' field. I am not sure what the best way to do this is. I don't want the states to repeat like they do in my current table. I would like each state to have a 2007 count and a 2020 count, instead of having two of the same states (one with a 2007 count and one with a 2020 count).

KimberlyGarbade · Answer

I like it.  Live and learn. I didn't know data management had a pivot table tool.

DavidPike · Answer

Pivot Table (Data Management)—ArcGIS Pro | Documentation

Input field - extent

Pivot Field - temporal period

Value Field - count

Using this new table, you can then just add afield and do a field calculation on it such as (year 2007/ year 2020) *100 etc.

AndyAnderson · Answer

Select the 2007 records and export the selection as a new table. Delete the 2007 records from the original table. Change the column names in the two tables. Join the new table to the original table on the extent column. If you wish save as a new table.

— Andy