I have a table of average sale prices by school district monthly from jan2010-jan2020. I need to time slide or animate change via chloropleth. Time slider won't allow it. If I transpose the table from horizontal to vertical I can't join the data. Ideas?
Current table (Joined but will not time slide) :
District jan2010 etc.......
Beavercreek 240379 etc...
etc....
Transposed:
Month Beavercreek Madriver etc...
1/1/2010 240379 etc....
2/1/2010 241440 etc.....
etc... etc.... etc.....
