The file P18_04.xlsx contains monthly data since 1931 on the number of cooling degree-days (CDD, an index of the amount of energy to cool a home or business) in each of the United States and several combined regions. (The codes for the locations appear on the Locations sheet.) Some of the data is missing, as indicated by -9999 in various cells. Rearrange the data so that there are three long columns: Location (spelled out, such as Virginia or South Atlantic), Month (such as Jan-1941), and CDD. Replace all -9999 values with blanks. Then show how a pivot table can be used to create a time series graph for any selected location?