ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Temporal data in separate fields

  • Reformatting a table that has time in separate columns

Very commonly, temporal data is stored in columns or fields in your attribute or stand-alone tables. For instance, census data has time represented in columns. You can reformat a table that has time in separate columns for visualizing changes in the data over time.

Reformatting a table that has time in separate columns

Often you'll have time represented in columns in your attribute table, for instance, medical costs per county for 1990, 1991, 1992, and so on.

Table before formatting

To visualize this data through time, the table must be reformatted. The Transpose Fields tool can be used to reformat the fields into a row format.

Table after reformatting

Learn more about the Transpose Fields tool.

Related topics

  • Best practices for storing temporal data
  • Supported field formats

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal