1.  Browse to Census American Factfinder à Advanced Search: https://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml

2.  Topic: People à Age & Sex à Age

3.  Geography: All States

4.  Database ID: PEPAGESEX

5.  Unzip, open CSV, and save as Excel

6.  In Excel file create a new worksheet titled: “RawData”

7.  Copy A2:[bottom-right] and paste to RawData

8.  Delete Columns D:AG (beginning of Under 5).

9.  Delete columns AH:AIW (beginning of Median values)

10. Insert one column to the left of B

11. In B2 enter “=RIGHT(A2,2)” and paste to the bottom

12. Delete columns E:J.

13. Rename columns to: Id,FIPSCode,Id2,Geography,Both2010,Male2010,Female2010,Both2011,Male2011,Female2011,Both2012,Male2012,Female2012,Both2013,Male2013,Female2013,Both2014,Male2014,Female2014,Both2015,Male2015,Female2015,Both2016,Male2016,Female2016,Both2017,Male2017,Female2017

14. Truncate and import into the MySQL staging table: “aa_co_mu_demographics”.