ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for 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
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

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
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal