U.S. Census Bureau

Learn more about the features and functions of American FactFinder

Skip left-hand navigation

Tutorial 8: Transpose Rows and Columns

You must have the Adobe Flash Player plug-in offsite link icon installed to play this video.

Video transcript »

Skip video and media player

The Camtasia Studio video content presented here requires JavaScript to be enabled and the latest version of the Adobe Flash Player. If you are using a browser with JavaScript disabled please enable it now. Otherwise, please update your version of the free Adobe Flash Player by downloading here.

Video Transcript:

  • Welcome to the American FactFinder Transpose Rows and Columns Tutorial.
  • In this Tutorial, we will demonstrate how to:
    • Swap rows and columns in a table;
    • Save or Download the transposed table; and
    • Reset the transposed table back to its original display.
  • After viewing this tutorial, you will be able to modify a table view by transposing the rows and columns of a table in American FactFinder.
  • Let's begin with the 2008 Population Estimates table, GCT-T01.
  • From the Data Product Viewer Page, select Modify Table.
  • The Data Product Viewer is updated and a set of table tools displays.
  • Within the table tools, there are options to reset the table, show hidden rows/columns and transpose rows/columns of the table.
  • Before we select an option, let's look at the details of this table.
  • Notice that the table is organized by year across multiple geographies.
  • The geographies are the row headings and the years are the column headings.
  • To swap the rows and columns within the table, click Transpose Rows/Columns.
  • Notice that the display of the table includes the following changes:
    • The years are now the row headings and the geographies are the column headings.
    • A note has been added to the data viewer indicating that this is a modified view of the table.
    • Finally, notice the page controls at the top of the table. American FactFinder provides paging controls whenever the displayed table exceeds the row or column display limit.
  • You can bookmark or download the modified table once your modifications are complete.
  • Refer to the Modify Table tutorial for additional instructions on table modification.
  • Now, let's reset this table to its original view.
  • Click Reset Table.
  • A reset table confirmation dialog box displays.
  • Click OK.
  • The original view of the table is restored.
  • This concludes the Transpose Rows and Columns Tutorial.
  • In this tutorial, you learned how to:
    • Transpose the rows and columns of a table;
    • Save or Download the transposed table; and
    • Reset the transposed table back to its original display.
  • For more information, visit American FactFinder at factfinder.census.gov.