Creating New Field Values from Common Attributes

[AnnaWilson]

So I have a table with an ID field, month field, year field and an injection amount field. The table comes from 2016, so the year field is populated with 2016. The ID field is duplicated 12 times to fit the 1-12 month field. 

I am trying to create new fields like 1/16, 2/16, 3/16 and so on (there will be more years, but I'm just trying to do it with one now) with the injection amount values that were originally its own fields, populating the new fields. 

Here's a picture to try to explain more 

There are several thousand values so I don't want to have to do it manually. If there is a geoprocessing tool that might help me out, I would much appreciate it. 

Thanks!

[DanPatterson]

Summary Statistics (Analysis)—ArcGIS Pro | Documentation

with the case field as ID year and month

might work

[DuncanHornby · Accepted solution]

I would suggest you explore the Pivot Table tool then do a row sum to get that final field.

[AnnaWilson]

This worked. Thank you so much!