Creating a visual representation tied with multiple data points tied to one geographic value

[MayaAlmoussa]

Hi all! I want to create multiple data points over time on a map (like Sliding Timer Effect). One of the columns in the data table has location "codes" that correspond to a specific location on the map. The other columns are "Percent illness" for the years 2017, 2018, 2019 and "Years" . Each location code corresponds to a "percent illness" and "Year" value from 2017, 2018, 2019.  How can I tie data points from percent illness 2017 to the Year 2017, and then to the location code, data points from percent illness  2018 to Year 2018 and to the location codes, etc, then visualize changes over time? . For example: How can I create an animation on a map that shows the change from 52% in 2017 to 32% in 2018 in Location 1 (and the other locations simultaneously)? 

Location code	Percent Illness 2017	Year	Percent Illness 2018	Year
1	52%	2017	32%	2018
2	45%	2017	47%	2018
3	63%	2017	75%	2018

[DavidPike]

It's not in quite the right format to be time-enabled yet.

Each year and location/area will need its own row in the table. as below.

Something like Transpose Fields https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/transpose-fields.htm or wrangle it in Excel, Pandas etc.

You'll also need to join a geometry or X and Y to each location field.

Location Code Year Percent Illness

1	2017	52%
1	2018	32%
2	2017	45%
2	2018	47%
3	2017	63%
3	2018	75%

[MayaAlmoussa]

Thank you! I am going to try that!